| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add same header to entire workbook
can you add the same header to all worksheets in a workbook at one time
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a custom header in excel for an entire workbook? | Excel Discussion (Misc queries) | |||
| Name an Entire Workbook | Excel Discussion (Misc queries) | |||
| Name an Entire Workbook | Excel Discussion (Misc queries) | |||
| How do I repeat same custom header for entire workbook | Excel Discussion (Misc queries) | |||
| Can you put the same header/footer on the entire workbook? | Excel Worksheet Functions | |||
Hybrid Mode
