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

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.

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



"KathieMacFarlane" wrote:

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.

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

"KathieMacFarlane" wrote:

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.

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

On Wed, 26 Jan 2005 11:15:02 -0800, "KathieMacFarlane"
wrote:

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.