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.