Printing options for all sheets in a workbook?

  • Thread starter Thread starter Landy
  • Start date Start date
L

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
 
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
 
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
 
Back
Top