How can I copy page set up options from one sheet to another

  • Thread starter Thread starter Don Cinnamond
  • Start date Start date
D

Don Cinnamond

I have a template which I copy into multiple sheets and then just enter data.
All calulations, formats everything copies from sheet to sheet. But the
page set up does not. So every time I have to adjust margins, landscape,
header, etc. Is there a way to copy the page set up? Or can I make a
single page set up that applies to all the sheets in a workbook? Thanks.
 
If you are copying by right-click on the sheet tab and Move or Copy>Create a
copy then the page setup should go with the copy.

Is this not happening or are you copying in some other manner?

You could select all sheets after the fact and do your page setup on the
active sheet which would be done to all selected sheets.


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 06:59:01 -0700, Don Cinnamond <Don
 

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

Copy formatting (headers, margins, etc) to another sheet? 3
Copying format changes from one sheet to another 4
Insert sheet template loses page setup (2010) 2
Merge Multiple workbook sheets into one workbook 0
Formatting problem copying sheet 3
Copy page layout and margin from sheet to sheet 1
I accidiently deleted a 12 page workbook, how do I get it back? 1
Can I apply page settings to all sheets in Excel? 4

Back
Top