
Signature
Jason Michel
junk@ns.condonconsulting.com
(remove ns. for direct email)
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

Signature
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
> 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
[quoted text clipped - 3 lines]
>
> Thanks in advance!
Jason M - 29 Jan 2007 17:29 GMT
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?
> Michel,
>
[quoted text clipped - 24 lines]
>>
>> Thanks in advance!
Paul B - 30 Jan 2007 20:28 GMT
Jason, I don't think that can be done from Excel, but maybe someone will
prove me wrong

Signature
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
> 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
[quoted text clipped - 29 lines]
>>>
>>> Thanks in advance!