Setting up Printing

[Guest]

I have data on a worksheet for each week of the year i.e tab 1 is week 1 tab2
is week 2 and so on until week 52. I need to set the whole worksheet to
print them all in the same format. I am currently changing eack week in the
page setup box manually. Is there a way to set the whole worksheet to print
in the same style and margins etc..

Many thanks to anyone who can help me.

 

[Don Guillett]

Why not set up one and copy that one for each new week or have all one ONE
sheet and filter the week or record a macro while doing it manually and use
that macro (cleaned up) to set up each sheet or select all sheets and do the
setup.

 

[Gord Dibben]

Right-click on a sheet and "select all sheets"

Do your print setup on the active sheet and will be done to all sheets.

NOTE: you cannot set Print Range and Rows to repeat at top on Grouped sheets.

You would require macro code for those two items. All else can be replicated.


Gord Dibben MS Excel MVP