PDF Conversion Issues

How to Fix Excel PDF Export Changing Fill Colors to Grayscale

Bushra ParveenBushra Parveen Nov 3, 2026 869 views

Question details

The user wants to export or print an Excel spreadsheet to PDF without the cell fill colors converting to grayscale.

How to Fix Excel PDF Export Changing Fill Colors to Grayscale
Product
Excel
Device & OS
not provided
Scenario
Saving, exporting, or printing an Excel spreadsheet as a PDF document.
Observed behavior
Cell fill colors appear in grayscale in the generated PDF, even though text and images retain their original colors.
Before you start

Verify that your computer's default printer is set to print in color, as Excel often utilizes default printer drivers to render the page layout and colors before generating a PDF file.

Solution 1Recommended

Disable Black and White Options in Page Setup

Excel's Page Setup has specific print settings that can force the output to grayscale. Disabling them ensures colors are preserved.

Excel's print settings directly influence how a file is rendered when exporting to PDF. If the worksheet is configured to print in draft mode or black and white, the resulting PDF will mirror these limitations.

1
Open Page Setup

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

2
Check Sheet Print Settings

In the Page Setup window, switch to the 'Sheet' tab. Under the 'Print' section, make sure the 'Black and white' and 'Draft quality' checkboxes are unchecked.

3
Verify Printer Options

Click the 'Options' button to open your printer properties. Ensure that the color mode is set to 'Color' rather than 'Grayscale' or 'Monochrome'.

4
Apply and Export

Click 'OK' to save the settings, then attempt to save or print your document to PDF again.

Disable Black and White Options in Page Setup
Settings Applied: Once these settings are corrected, your PDF should display the exact cell fill colors you see in the Excel worksheet.
Free Microsoft Office alternative

Export Spreadsheets to High-Quality PDFs with WPS Office

Tired of struggling with Excel's printer-dependent PDF exports? WPS Office is a free, lightweight Microsoft Office alternative that features an advanced, built-in PDF exporter. It perfectly preserves your cell fill colors, charts, and layouts without requiring complex printer configuration.

  1. 1. Download WPS Office: Download and install WPS Office for free from the official website.
  2. 2. Open Your Spreadsheet: Open your .xlsx or .xls file using WPS Spreadsheet.
  3. 3. Export to PDF: Go to the Menu and select 'Export to PDF'. Your colors will be retained perfectly.
Seamlessly open and edit Microsoft Excel formats (.xlsx, .xls) with high compatibility.Built-in Export to PDF feature that accurately retains all original fill colors.Lightweight design that runs smoothly on almost any device.Familiar user interface for a zero-learning-curve transition.
microsoft office alternative - wps office

Frequently Asked Questions

Is Adobe Reader causing my PDF to display in grayscale?

No. Adobe Reader is purely a viewing application and does not alter the file's content. The conversion to grayscale happens during the PDF creation process in Excel.

Why do text and images stay in color while cell fills turn gray?

This specific behavior is usually caused by Excel's 'Black and white' print setting in the Page Setup menu, which removes cell shading but sometimes leaves inserted objects or certain font colors intact depending on the driver.

Does my physical printer affect Excel's Save as PDF feature?

Yes. Excel heavily relies on the default printer's driver to calculate page layout and color rendering. If your default printer is a monochrome printer, it can force Excel's PDF exports into grayscale.