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?

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?

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