Print options in Excel are applied per worksheet
When a new workbook is created, Microsoft Excel reads the default settings of the printer driver of the default printer. Most of the settings from the printer driver are applied as default print attributes to each worksheet in the new workbook.
For example, if the driver for the default printer is set to print in black-and-white, when the new workbook is created, each worksheet will also contain the black-and-white print setting as a default attribute and will print in black-and-white. However, if you select multiple worksheets to print and also select to print in color, only the first selected worksheet will print in color.
Important Some printer drivers contain settings which are stored by Excel at the workbook level. These settings vary from printer to printer and depend on the manufacturer of the printer.
Article ID: 2526211 - Last Review: 09/23/2015 07:49:00 - Revision: 6.0
- consumeroff2010track KB2526211