Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to print a workbook but worksheets have diff print areas
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to print a workbook but worksheets have diff print areas
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: Macro to print areas in mulptiple worksheets | Excel Discussion (Misc queries) | |||
Print Areas | Excel Discussion (Misc queries) | |||
print areas on one page to print? | Excel Discussion (Misc queries) | |||
How do I print a workbook in but only print selected worksheets? | Excel Discussion (Misc queries) | |||
How do I print an entire workbook w/diff orientatns to Adobe PDF? | Excel Discussion (Misc queries) |