LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair
 
Posts: n/a
Default Can I apply page settings to all sheets in Excel?

In article , <Andy wrote:
Hi

Group the sheets you want to change. Change one of them and they all follow
suite!!
To group, click the first tab and then Shift-click the last tab.


As an extra piece of advice, once you have finished, be sure to ungroup your
sheets again. You can do a lot of damage in a short time if you don't :)


"Richard S" <Richard wrote in message
...
I would like to apply Page Setup settings (margins, header/footer, etc.) to
all sheets of an existing Excel file without going into each sheet. I know
I
can copy a sheet and the settings will be copied with it, but this is an
existing file.



Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)

 
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
Excel ignores boot-time regional settings when interpreting a date [email protected] Excel Discussion (Misc queries) 2 November 4th 05 11:44 AM
excel 2003 changing saved print settings George Applegate Excel Discussion (Misc queries) 0 November 1st 05 06:50 PM
Varying page Excel report judypudy Excel Discussion (Misc queries) 6 July 13th 05 08:39 PM
changing page break in an excel file ibs81 New Users to Excel 1 April 14th 05 07:03 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM


All times are GMT +1. The time now is 01:27 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"