add same header to entire workbook
 

can you add the same header to all worksheets in a workbook at one time

add same header to entire workbook
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"tracysiscpa" wrote in message
...
can you add the same header to all worksheets in a workbook at one time

add same header to entire workbook
 

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

On Wed, 4 Mar 2009 16:40:04 -0400, "Bernard Liengme"
wrote:

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

add same header to entire workbook
 

Good point
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Wed, 4 Mar 2009 16:40:04 -0400, "Bernard Liengme"
wrote:

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