add same header to entire workbook

  • Thread starter Thread starter tracysiscpa
  • Start date Start date
Group the sheets: click on the tab of Sheet1; hold SHIFT; click on tab of
last sheet.
Note how all sheets tabs have the same shading/colour when grouped
File | PageSetUp and add headers/footers
Ungroup sheets by clicking an sheet tab
best wishes
 
My usual add-on<g>

One caveat with this method.

ALL print settings except for print range and rows to repeat at top will be
changed to that of the activesheet.

So, if you wish to maintain different margins or other sheet settings for
each sheet, do not use this method.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Headers and Footer to an Entire Workbook?? 6
Insert work sheet with Custom headers 4
transferring headers and footers 1
Sharing workbooks limitations - Merged Cells 12
Excel Highlighting duplicates 0
Drop Down List Contains the List Header Row 1
Find & Replace in Headers 5
Change Header & Footer Info w/ Worksheet Option Buttons 1

Back
Top