Share Excel worksheet custom header/footer throughout workbook.

[Guest]

I normally create workbooks with several worksheets. These worksheets
usually have identical formats, including what I want in the custom header
and footer. I am continuosly frustrated by not being able to select an
option that will automatically share the Page setup options across the
worksheets within the workbook. I am forced to go to each worksheet and
enter the custom information.

 

[Gord Dibben]

zilla

If you group the sheets and make the setup on the first sheet, all others will
be done simultaneously.

Group sheets by CRTL + Click for non-contiguous sheets or SHIFT + Click for
all sheets or right-click on a tab and "select all sheets".

Note: there are a few features not available with grouped sheets.

Print Area cannot be set, Print Titles cannot be set.

Headers and footers can definitely be set for all sheeys.


Gord Dibben Excel MVP