How do I copy page set up attributes from one worksheet to anothe.

G

Guest

How do you copy page set up attributes from one worksheet to another. For
examle retaining the margins, the landscape settings, and the "fit to page"
settings.
 
G

Guest

If you "save as" and rename the file name, you are making a replica of the
sheet, and renaming as another.
 
G

Guest

....Or you can right click on the sheet's tab on the bottom of your page and
there is an option called "Move or copy" Choose that one and you will have
an exact copy of your sheet - on a new sheet (tab) with all the same settings.
 
G

Gord Dibben

Kathie

Right-click on first sheet tab and "select all sheets".

Do your page setup on active sheet and it will be done to all sheets.

If first sheet already has the settings you want, just do the File>Page Setup
and OK.

Settings will be transferred to other sheets.

Note: you cannot set print range and rows to repeat at top.

DO NOT FORGET to ungroup the sheets when Page Setup is complete.


Gord Dibben Excel MVP
 

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

Setting up page template 1
How do I copy the page set up from one worksheet to another? 2
Formula, Macro, or VBA code to find and insert 3
Workbook Printing Page Format 3
Copy custom footer across multiple sheets 3
How do I copy Page Setups from one Sheet to Another sheet? 1
Print and page settings of workbook 8
spreasheet too small to read in one page how can i fix this 2

Top