Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2007

Tip: Looking for answers? Try searching our database.

Apply page setup to ALL sheets?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jason M - 29 Jan 2007 15:19 GMT
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!

Signature

Jason Michel
junk@ns.condonconsulting.com
(remove ns. for direct email)

Paul B - 29 Jan 2007 15:30 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.