#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 75
Default Page Setup

In Excel 2007, once you indicate all your Page Setup settings, headers and
footers on the first worksheet€¦is there a way to apply them to other
subsequent worksheets? Or do you have to set all the settings for each
worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Page Setup

Right click on the sheet tab Select all sheets

Add your header and footer...This will have this set for all sheets.

Once done right click on the sheet tab and 'Ungroup sheets'


If this post helps click Yes
---------------
Jacob Skaria


"Té" wrote:

In Excel 2007, once you indicate all your Page Setup settings, headers and
footers on the first worksheet€¦is there a way to apply them to other
subsequent worksheets? Or do you have to set all the settings for each
worksheet?

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
Page layout - page setup - items disabled Bill D - Hubbard & Co Excel Discussion (Misc queries) 6 February 2nd 10 04:34 PM
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE fred Excel Discussion (Misc queries) 1 August 11th 08 04:54 PM
Page Setup when saving a worksheet as a web page pattyw Excel Discussion (Misc queries) 3 July 29th 08 09:25 PM
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE Randy Excel Worksheet Functions 1 February 8th 07 06:15 PM
Under Page Setup the page option of Ledger - for Office XP Turbo Excel Discussion (Misc queries) 2 September 27th 06 02:46 AM


All times are GMT +1. The time now is 10:12 PM.

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"