Fix Excel 365 Workbooks Printing Only in Black and White
Question details
The user needs affected Excel workbooks to print in color.

- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Printing colored worksheets from certain Excel workbooks to a color printer.
- Observed behavior
- The affected worksheets appear in color in Print Preview but print in black and white. Word, new Excel workbooks, and other users print in color on the same printer.
Open an affected workbook and confirm that the intended color printer is selected under File > Print. Have a worksheet that prints correctly available for comparison.
Check the worksheet and printer color settings
Use this first to rule out black-and-white settings saved for the affected worksheet or selected printer.
In the affected worksheet, select Page Layout and open the Page Setup dialog using the small launcher in the Page Setup group.
On the Sheet tab, clear the Black and white checkbox if it is selected, then select OK. Repeat for other affected sheets.
Go to File > Print, select the intended printer, and open Printer Properties. Choose color printing and turn off grayscale or monochrome if those options are available.
Select Print and check whether the worksheet now prints in color.

Test the affected content in a new workbook
Use a new workbook to check whether the problem is tied to the original workbook or its print settings.
Update Excel and test for add-in interference
Use this if the affected workbook still prints without color after checking its settings.
Print Excel Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening, editing, and printing spreadsheets. Its Microsoft Office format support makes it easy to move existing workbooks to WPS, though it does not fix Excel's own printing settings.

Frequently Asked Questions
Why does Excel show color in Print Preview but print in black and white?
A worksheet's Black and white setting or a printer's grayscale setting may override the color shown in the preview. Check Page Layout > Page Setup > Sheet and File > Print > Printer Properties.
Can the black-and-white setting affect only one worksheet?
Yes. Check the Black and white option on the Sheet tab of Page Setup for each affected worksheet.
How can I tell whether an Excel add-in is causing the problem?
On Windows, close Excel, open Run, and enter excel /safe. Print the affected workbook in Safe Mode. If it prints in color, restart Excel normally and test add-ins through File > Options > Add-ins.
What does a successful print from a new workbook tell me?
If copied content prints in color from a new workbook using the same printer, the issue may be tied to the original workbook or its print settings. Compare Page Setup and printer options in both workbooks.
Where can I find my Excel version for support?
In Excel, select File > Account and look under Product Information for the version details.




