How do I copy Page Setups from one Sheet to Another sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I copy the page set up from one worksheet to another? 2
Grouped sheets page formatting will copy the header 3
Copy custom footer across multiple sheets 3
Grouping sheets copies Header across to all sheets 1
formatting sheets in a workbook 4
How do I copy formatting from 1 sheet to next in same workbook? 1
Insert sheet template loses page setup (2010) 2
How do I copy page set up attributes from one worksheet to anothe. 3

Back
Top