Page Set-up

S

Staurt Steven

I want to set up different worksheets to print, by doing
the following:

Having them centred vertically and horizontally
Have them fit to 1 page wide by 1 tall
Have the Header showing "&Tab"

How do I do this for more than 1 sheet at a time????
 
A

Andy B

Hi

Group the sheets (select each while holding Ctrl) you want to change and
change the settings on one. It will copy the settings to the rest for you!
Don't forget to ungroup the sheets afterwards.
 
Top