Help with print setup

D

Daniel

Hi

I am using Excel 2000 SP3.
I have a Workbook with 59 worksheets
and need to print out a part
of each worksheet, it is the same area
on every worksheet, is there a way I can set this up without having to set
Print area and Page setup
on each worksheet.

thanks

Daniel
 
D

Dave Peterson

Group all the worksheets.

Right click on a worksheet tab
select "select all sheets"

do the page setup once.

rightClick on any of the worksheet tabs and select "ungroup sheets"

If you leave those sheets grouped and start working on them, then almost
everything you do to one, you do to all in the group. It can be dangerous!
 
Top