Printing Problems

Fix Excel 365 Workbooks Printing Only in Black and White

Maira MehtabMaira Mehtab Nov 22, 2026 868 views

Question details

The user needs affected Excel workbooks to print in color.

Fix Excel 365 Workbooks Printing Only in Black and White
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Page Setup

In the affected worksheet, select Page Layout and open the Page Setup dialog using the small launcher in the Page Setup group.

2
Turn off black-and-white printing

On the Sheet tab, clear the Black and white checkbox if it is selected, then select OK. Repeat for other affected sheets.

3
Check printer properties

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.

4
Print a test page

Select Print and check whether the worksheet now prints in color.

Check the worksheet and printer color settings
Free Microsoft Office alternative

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.

Open and print colored worksheets in WPS SpreadsheetCompatible with Microsoft Excel XLSX and XLS formatsFamiliar spreadsheet interface for an easy transitionFree and lightweight office suite
microsoft office alternative - wps office

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.