How can I apply print area and page setup to entire workbook?
 

without having to set up for each worksheet individually?

How can I apply print area and page setup to entire workbook?
 

Right click on any sheet tab, select SELECT ALL SHEETS, then set your print
ranges as you normally would. All visible worksheets will be printed with
the same print range.
--
Kevin Backmann


"Simon Willard" wrote:

without having to set up for each worksheet individually?