Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff Graham
 
Posts: n/a
Default How can I copy page setup settings to other worksheets? Thanks

I would like to copy the "page setup" info, such as margins, headers/footers,
to other worksheets, but cannot figure out how??
Thanks,

  #2   Report Post  
Paul B
 
Posts: n/a
Default

Jeff, here is one way, 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 and you'll also notice that all sheets have
the same page settings!


--
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

"Jeff Graham" <Jeff wrote in message
...
I would like to copy the "page setup" info, such as margins,

headers/footers,
to other worksheets, but cannot figure out how??
Thanks,



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
Copy Excel worksheets TedDSC Excel Discussion (Misc queries) 2 December 27th 04 09:59 PM
Page Setup Gogetter20 Excel Discussion (Misc queries) 0 December 16th 04 08:43 PM
Excel page settings Rafi Excel Discussion (Misc queries) 3 December 15th 04 10:07 PM
Linking to Worksheets on Excel -Saved Web Page Lawman Links and Linking in Excel 3 December 8th 04 08:13 AM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 10:12 PM


All times are GMT +1. The time now is 04:39 AM.

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"