LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
gat3991
 
Posts: n/a
Default How do I set up global headers and footers in Excel?

Answer: Select multiple tabs with <cntrl click or <shift click. Go to
File--Page Set-up. Select Header/Footer tab. Make desired modifications.
This will apply your headers and footers to all selected sheets. CAUTION: be
sure to select only ONE tab again before editing data, or else you will be
editing data in all selected tabs.
 
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
Font Colors with headers and Footers sip8316 Excel Discussion (Misc queries) 1 June 18th 05 12:40 AM
Pre-set headers and footers for new worksheets robertwesley Excel Discussion (Misc queries) 4 April 27th 05 11:14 AM
Losing my headers and footers when I copy the file StuThomson Excel Discussion (Misc queries) 1 December 29th 04 02:55 PM
Better support for dynamic content within headers and footers Anvil Scott Excel Discussion (Misc queries) 1 December 21st 04 08:33 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 03:39 AM.

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

About Us

"It's about Microsoft Excel"