FORMATTING MULTIPLE SHEETS

[lzweifel]

Hello Everyone,

Is there a way to apply one format (ie. page settings) for multiple sheets at a time?

Thanks for your time!

 

[shajueasow]

Have you tried grouping the required sheets (selecting the requred sheets with CTRL key pressed) and then applying the format...

 

[lzweifel]

Yes, that worked - thanks so much

 

[Peter_SSs]

lzweifel

Also, if you already have one of the sheets set up how you want it:
1. Select that sheet.
2. Now select the other sheets using CTRL (or SHIFT)
3. File|Page Setup...|OK

That is, if you select the 'good' sheet first then you don't have to actually 'set' anything on the others, the format of the 'good' sheet will automatically be transferred to the others just by the OK in Page Setup.