Printing Problems

How to Fix Excel Worksheets Printing Only in Black and White

Huma Ashraf ChHuma Ashraf Ch Nov 3, 2026 873 views

Question details

The user needs to resolve an issue where an Excel worksheet outputs in black and white during print preview and final printing, despite containing colored cells.

How to Fix Excel Worksheets That Print Only in Black and White
Product
Excel
Device & OS
not provided
Scenario
Attempting to print a spreadsheet containing colored text or cell backgrounds.
Observed behavior
The print preview and printed pages display colored cells in black and white, even though other workbooks print in color correctly.
Before you start

Verify that your printer has sufficient color ink or toner and that it is not globally set to grayscale in your computer's system settings.

Solution 1Recommended

Disable the Black and White Setting in Page Setup

This is the most common fix when a specific worksheet refuses to print in color while others work perfectly.

Excel has a worksheet-specific setting that forces the page to print in black and white. If this gets toggled on accidentally, the document will ignore your printer's color settings. Disabling this option will restore normal color printing.

1
Open the Page Setup menu

Navigate to the 'Page Layout' tab on the Excel ribbon, look for the 'Page Setup' group, and click the small dialog box launcher arrow in the bottom-right corner.

2
Navigate to the Sheet tab

In the Page Setup dialog window, click on the 'Sheet' tab located at the far right.

3
Clear the Black and white checkbox

Under the 'Print' section, locate the 'Black and white' checkbox. Click to remove the checkmark.

4
Verify with Print Preview

Click the 'Print Preview' button within the dialog or press Ctrl+P to ensure your colored cells now display correctly in the preview pane before printing.

Disable the Black and White Setting in Page Setup
Worksheet-Specific Application: Remember that this setting applies individually to each worksheet. If you have multiple sheets printing in black and white, you will need to select all affected sheets or repeat this process for each one.
Seamless Spreadsheet Printing

Easily Manage Print Settings with WPS Office

WPS Office provides an intuitive Page Layout interface to easily control exactly how your spreadsheets print, ensuring your colored data is accurately represented on paper without hassle.

  1. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document containing the colored cells.
  2. 2. Access the Page Layout tools: Click on the 'Page Layout' tab located in the top navigation ribbon.
  3. 3. Open the Page Setup dialog: Click the 'Page Setup' button to open the detailed printing preferences.
  4. 4. Uncheck Black and White: Switch to the 'Sheet' tab, ensure 'Black and white' is unchecked in the Print section, and click OK to print in vibrant color.
100% compatible with Microsoft Excel formats (.xls, .xlsx)Streamlined print preview and page setup interfaceFree to use with comprehensive spreadsheet capabilitiesLightweight installation and fast performance
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel file print in black and white when the printer is set to color?

This happens because Excel's worksheet-level 'Black and white' setting in the Page Setup menu overrides the global color settings of your printer. Unchecking this option will restore color output.

Does the 'Black and white' print setting affect the whole workbook?

No, the 'Black and white' setting is applied on a per-worksheet basis. If multiple sheets are affected, you must group them or adjust the setting for each sheet individually.

What if unchecking the Black and White box doesn't work?

If the issue persists, check if your printer driver is forcing grayscale in the system 'Devices and Printers' menu. Additionally, ensure that the cells actually have a fill color applied and are not just conditionally formatted to look blank during print.

Is there a fast way to check if my sheet is set to print in black and white?

Yes, simply press Ctrl+P to open the Print Preview. If your document contains colored cells but the preview shows only shades of gray, the black and white setting or a printer grayscale preference is currently active.