Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 77
Default Copy headers and footers to other pages?

Is there a way to copy headers and footers to different sheets in the same
file?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Copy headers and footers to other pages?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy headers/footers to multiple different workbooks? mjzvbms Excel Discussion (Misc queries) 0 August 16th 06 04:10 PM
How to copy headers/footers between worksheets BruceD Excel Discussion (Misc queries) 2 July 18th 06 08:50 PM
How to copy headers/footers across worksheets BruceD Excel Discussion (Misc queries) 5 May 31st 06 07:06 PM
Copy Headers and Footers between wookbooks Dave Excel Discussion (Misc queries) 1 May 6th 06 03:47 PM
In Excel, can I copy Headers and Footers between Worksheets? Brian Excel Worksheet Functions 1 November 12th 04 01:14 PM


All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"