Need to print a workbook but worksheets have diff print areas

  • Thread starter Thread starter Angela Steele
  • Start date Start date
A

Angela Steele

I have an Excel workbook that contains about 75+ worksheets. I need to print
each worksheet in the entire workbook, but each worksheet does not have the
same print area for the data we need to print - and due to the nature of the
data, we CANNOT change it so that the data will fall into the same print area
on each sheet. Currently, we are having to go to each individual worksheet,
highlight & set the print area, and then print them all. Is there a
faster/better way to print these worksheets?
 
When you select File | Print, then check Print Entire Workbook, Excel
will print every sheet, with the print area settings you set up for
each sheet. Otherwise, if you don't set the print area for each
sheet, it will use the default settings for every sheet, which
frequently are not desirable.
 
Back
Top