Printing options for all sheets in a workbook?

[Landy]

One of the most painful things in Excel (2003) is that you have to set up
the printing options (margins, header, footer, scale etc.) for all sheets in
a workbook individually. Is there a hidden option somewhere that says
"apply print options to all sheets in workbook"?
cheers
Bill

 

[Pete_UK]

You can group sheets together by right-clicking on a sheet tab and
selecting Group all sheets. Then whatever you do to one sheet will
apply to all sheets. So, if you set your print options (headers,
footers, margins etc) in this mode then all sheets will take on those
options.

Remember to ungroup the sheets when you are finished.

Hope this helps.

Pete

 

[Landy]

Thanks Pete! Interestingly this works if I go straight to page setup, but
if go there via the print preview it doesn't!
cheers
Bill

 

[Pete_UK]

You're welcome, Bill - thanks for feeding back.

Pete