printing a header in Excel

  • Thread starter Thread starter hi-fi
  • Start date Start date
H

hi-fi

How can I print the same header I have created on the top of the excel file
on every sheet. Example: I have an excel file with one header on the top of
the file. My excel file has 3 pages for print. I need to have on every
printed page the same header on top of every page.
Thank you in advance for your help!

Stefan Nenkov
 
If you have already defined a header for Sheet1, then group all the
other sheets (select that sheet and right-click the sheet tab and
choose Select All Sheets or Group sheets). Then whatever you do will
appear in all sheets. So, navigate to the header as if you are going
to edit it, and then OK your way out. Ungroup the sheets (by right-
clicking on a sheet tab) and now all your sheets will have that same
header.

Hope this helps.

Pete
 
As well as most of the other print settings for Sheet1.

Print Range and Rows to Repeat are exceptions.


Gord Dibben MS Excel MVP
 
Back
Top