How to Fix Excel Worksheets Printing Only in Black and White
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.

- 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.
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.
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.
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.
In the Page Setup dialog window, click on the 'Sheet' tab located at the far right.
Under the 'Print' section, locate the 'Black and white' checkbox. Click to remove the checkmark.
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.

Check Printer Properties for Color Preferences
Use this solution if adjusting the Page Setup does not resolve the issue, as the printer driver itself might be overriding Excel's instructions.
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. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document containing the colored cells.
- 2. Access the Page Layout tools: Click on the 'Page Layout' tab located in the top navigation ribbon.
- 3. Open the Page Setup dialog: Click the 'Page Setup' button to open the detailed printing preferences.
- 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.

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.




