how to setup all pages at the same time?

[dora]

I want to print 40 worksheet with the same setup, I don't know how to do.
I don't know to take the time for each, does exist some method that help me?

 

[Gord Dibben]

Dora

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.

To do that requires VBA code.

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


Gord Dibben Excel MVP