Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get the same header/footer to print on each page of a wo.
I've made a custom header / footer how do I get it to print on each page of a
work book without having to re-create on each page -- Stephen Connolly |
#2
|
|||
|
|||
Group the worksheets by clicking the first worksheet tab,
hold down the <Shift key, and click the last worksheet tab. Now set up the header under File Page Setup. To ungroup, click any one of the worksheet tabs, or right- click one of them and select "Ungroup". HTH Jason Atlanta, GA -----Original Message----- I've made a custom header / footer how do I get it to print on each page of a work book without having to re-create on each page -- Stephen Connolly . |
#3
|
|||
|
|||
Stephen,
You could record a new macro with you going into the Header/Footer dialog for the sheet that contains the footer you want to copy This will create a macro which, because all its sheet references are to "currentsheet" can easily be run against all your other sheets, too. Thus: 1. Go into sheet containing footer 2. Record a new macro 3. Click View Header/Footer 4. Click OK 5. Stop recording 6. Click on a sheet that requires the header/footer details 7. Run the macro. 8. repeat Steps 6-7 for all sheets that need modifying. Hope this helps Pete "Stephen Connolly" wrote: I've made a custom header / footer how do I get it to print on each page of a work book without having to re-create on each page -- Stephen Connolly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print and Print Preview don't match screen | Excel Worksheet Functions | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) |