Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set up a repeating header or footer to entire workbook
Is there way to set up a repeating header rather than going to each tab in a
workbook? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
set up a repeating header or footer to entire workbook
Put the sheets in Group mode (Right-click the sheet tab, select Select All
Sheets). With the sheet which has the correct header on it the active sheet, simply visit Page Setup and click OK. Right-click the sheet tab and select Ungroup Sheets. All sheets now have the same header & footer. From my book, on page 91! - "This isn't Excel, it's Magic" - http://www.iil.com/iil/excelmagic Bob Umlas "M2PM2" wrote in message ... Is there way to set up a repeating header rather than going to each tab in a workbook? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
set up a repeating header or footer to entire workbook
That's great! Bob. I cannot help wondering how someone can unlock a secret like this? Surely it is not all serendipity. -- davidm ------------------------------------------------------------------------ davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645 View this thread: http://www.excelforum.com/showthread...hreadid=501509 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Headers and Footer to an Entire Workbook?? | Excel Discussion (Misc queries) | |||
Header/Footer on entire workbook | Excel Worksheet Functions | |||
add same header to entire workbook | Excel Discussion (Misc queries) | |||
header/footer for the whole workbook | Excel Worksheet Functions | |||
Can you put the same header/footer on the entire workbook? | Excel Worksheet Functions |