Page header and footer for charts from my template

[Verktum]

I plot a lot of Y vs X data as scatter plots. Usually, I want the graphs as
separate sheets. For these sheets, I want a standardized header and footer.
Presently, I do this manually by
1. Select the chart location as New sheet, with a name
2. In the new sheet, click the Print Preview button
3. Click Setup...
4. enter Custom Header and Custom Footer data.

I always enter the same data in step 4 above. It should be ideal for a
template. Is there a way to use a template for this?

 

[BoniM]

Next time you add charts, assuming you add them to end of your workbook,
click the last sheet that already has a header/footer, shift click on the
last new sheet to group them. Choose File, Page Setup, on the header/footer
tab, you should see the data from the first (already done) worksheet in your
selection. Click ok and now it has been applied to all of the selected
sheets.
Bottom line, if you do page setup of headers and footers (or anything else
for that matter) in page setup from the menu bar instead of from print
preview, it will apply to all selected sheets as long as they are all the
same kind of sheet. Select all chart sheets, or all regular worksheets.
Select first sheet and shift click last sheet will group those two sheets
and all between. ctrl click will allow you to add or remove individual
sheets.
As soon as you have finished, be sure to ungroup by right clicking a
selected sheet tab and choose ungroup sheets, or click a sheet outside of the
group.
(editing done on a sheet in a group applies to all sheets)