Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a way to copy headers and footers to different sheets in the same
file? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Select the sheet where the header/footer is set up. You can group
sheets together by holding the CTRL key down and clicking on the sheet tab. When you have your group, release the CTRL key, and now anything that you do in one sheet will also be done in the other sheets. Click on File | Page Setup | Header/Footer tab and then click Custom Header as if you were going to edit it. Do the same for Custom Footer, then come out of that and ungroup the sheets by clicking on another sheet tab (or right click a sheet tab and Ungroup sheets). You should now find that each of the sheets that you had grouped have the same header and footer. Hope this helps. Pete On Aug 3, 9:52 pm, Laura wrote: Is there a way to copy headers and footers to different sheets in the same file? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I copy headers/footers to multiple different workbooks? | Excel Discussion (Misc queries) | |||
How to copy headers/footers between worksheets | Excel Discussion (Misc queries) | |||
How to copy headers/footers across worksheets | Excel Discussion (Misc queries) | |||
Copy Headers and Footers between wookbooks | Excel Discussion (Misc queries) | |||
In Excel, can I copy Headers and Footers between Worksheets? | Excel Worksheet Functions |