Print options in Excel are applied per worksheet

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article describes how printer settings are applied per worksheet in Microsoft Excel. 
More information
In Excel, every worksheet uses its own printer settings.

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.
excel color duplex landscape portrait two-sided printer settings setting option XL2013 XL2010 XL2007 XL2003 Excel2013 Excel2010 Excel2007 Excel2003
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2526211 - Last Review: 09/23/2015 07:49:00 - Revision: 6.0

Microsoft Excel 2013, Microsoft Excel 2010, Microsoft Office Excel 2007, Microsoft Office Excel 2003, Excel 2016

  • consumeroff2010track KB2526211