If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
add same header to entire workbook
can you add the same header to all worksheets in a workbook at one time
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
add same header to entire workbook
My usual add-ong
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 |
#4
|
|||
|
|||
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-ong 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 |
Thread Tools | |
Display Modes | |
|
|