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

On Feb 4, 1:03*am, hi-fi wrote:
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

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

Print Range and Rows to Repeat are exceptions.


Gord Dibben MS Excel MVP

On Wed, 3 Feb 2010 17:12:49 -0800 (PST), Pete_UK
wrote:

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

On Feb 4, 1:03*am, hi-fi wrote:
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