Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff
 
Posts: n/a
Default How do I copy Page Setups from one Sheet to Another sheet?

I've set up margins within a worksheet and wish to copy that worksheet with
the same format. Doesn't seem to copy the margin settings. Am I missing
somethin?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

If you copy the whole worksheet (not just the cells), then the page setup will
travel with that worksheet.

Select your sheet to copy
Edit|move or copy sheet

If you want multiple worksheets to have the same page layout, you can select the
first and ctrl-click on the subsequent tabs.

Then File|page setup

You'll be getting all the worksheets that are grouped.

Remember to ungroup your sheets (just rightclick on one of the grouped
worksheets tabs and select "Ungroup Sheets".

Any change you make to one of the group, you make to all of the group.

Jeff wrote:

I've set up margins within a worksheet and wish to copy that worksheet with
the same format. Doesn't seem to copy the margin settings. Am I missing
somethin?


--

Dave Peterson
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 Page Setup from Sheet to Sheet? blank Excel Discussion (Misc queries) 3 May 21st 05 10:23 AM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
How do I keep page breaks for each page in a sheet without the co. notexcellent Excel Discussion (Misc queries) 0 February 9th 05 07:53 PM
Copy text from same cell on every sheet to title sheet? Jon Excel Discussion (Misc queries) 2 February 9th 05 03:11 PM
How do I copy page set up attributes from one worksheet to anothe. KathieMacFarlane Excel Worksheet Functions 3 January 26th 05 10:54 PM


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