How to Fix Excel Color Bars Not Printing (Fix Black and White)
Question details
The user needs to resolve an issue where color bars and formatting in a specific Excel workbook print in black and white, despite displaying in color on the screen.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to print an Excel spreadsheet that contains color elements, but the printed output forces a grayscale or black-and-white result for one specific file.
- Observed behavior
- Excel color bars and formatting appear correctly on the computer screen but print in black and white. This issue occurs in one specific workbook, while other files print in color successfully.
Verify that your printer has sufficient color ink or toner and that the system-level printer properties are not set to monochrome or grayscale.
Disable the Black and White Print Setting in Page Setup
This solution adjusts the worksheet-specific print settings that force Excel to print in monochrome regardless of your physical printer's capabilities.
Excel saves specific print settings for individual worksheets. If 'Black and white' is enabled in the Page Setup, the document will ignore your system printer's color capabilities.
Open the affected workbook in Excel and click on the 'Page Layout' tab located in the top ribbon.
Locate the 'Page Setup' group and click on the 'Print Titles' button to open the Page Setup dialog box.
In the Page Setup dialog, select the 'Sheet' tab. Look under the Print section and uncheck the 'Black and white' checkbox.
Click 'OK' to save the settings. Print your worksheet again to verify that the color bars and formatting print correctly.

Verify Printer Driver Properties
Use this method if the Page Setup settings are correct but the document still refuses to print in color.
Print Excel Color Bars Perfectly with WPS Spreadsheet
WPS Spreadsheet provides a highly compatible and intuitive interface for managing complex print settings, ensuring your color bars, charts, and conditional formatting look exactly the same on paper as they do on your screen.
- 1. Open your file in WPS Office: Launch WPS Spreadsheet and open the document experiencing the color printing issue.
- 2. Access Page Setup: Navigate to the 'Page Layout' tab and click the small dialog box launcher arrow in the bottom-right corner of the Page Setup group.
- 3. Uncheck Black and White: Go to the 'Sheet' tab, locate the Print section, uncheck the 'Black and white' print option, and click OK.
- 4. Print your document: Press Ctrl + P to open the print dialog, verify your colors in the real-time preview, and click Print.

Frequently Asked Questions
Why does Excel print in black and white when my printer is set to color?
Excel contains its own worksheet-level print settings that can override your system printer settings. If the 'Black and white' option is checked under the Page Setup menu's Sheet tab, Excel will force the document to print without color.
Will selecting 'Draft quality' affect color printing in my spreadsheets?
Yes, enabling 'Draft quality' in the Page Setup dialog can sometimes cause printers to bypass complex formatting, graphics, and certain color fills to save ink and print faster. Uncheck this option if you need high-quality color prints.
How do I apply color printing settings to all worksheets at once?
Hold down the Ctrl key and click each sheet tab at the bottom of your workbook to group them. Then, go to Page Layout > Print Titles > Sheet, and uncheck the 'Black and white' option. This applies the fix to all selected sheets simultaneously.




