Apply page setup to ALL sheets?

J

Jason M

Is there a way to get the page setup to apply to ALL the sheets in a
workbook. In other words to change the page setup for all the sheets in a
workbook so they are exactly the same or do I have to go through and do them
individually?

Thanks in advance!
 
P

Paul B

Michel,

Group the worksheets you want to change

Click on the first tab and ctrl-click on the other tabs, if you want all the
sheets right click on one and choose select all sheets.

Then do the page setup, most settings will be copied



If you already have one sheet set up like you want then with the sheet that
has the correct settings active, right-click on the sheet tab and select
"Select All Sheets", then use File/Page Setup and immediately click OK
(don't change anything). Click on some other worksheet
to get you out of "Group" mode now all sheets should have the same page
settings!



There are two EXCEPTIONS that I can think of
Print Range
Rows to repeat at top

Cannot be copied this way
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
J

Jason M

This worked for the page setup options, but it didn't apply my printer
setting options (the Options..) tab when you go to Page setup. Any help on
that one?
 
P

Paul B

Jason, I don't think that can be done from Excel, but maybe someone will
prove me wrong
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top