How to Fix Excel PDF Export Changing Fill Colors to Grayscale
Question details
The user wants to export or print an Excel spreadsheet to PDF without the cell fill colors converting 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.
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.
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.
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.
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.
Click the 'Options' button to open your printer properties. Ensure that the color mode is set to 'Color' rather than 'Grayscale' or 'Monochrome'.
Click 'OK' to save the settings, then attempt to save or print your document to PDF again.

Use Alternative PDF Creation Methods
Since PDF creation methods use different rendering engines, switching your export method can bypass color formatting bugs.
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. Download WPS Office: Download and install WPS Office for free from the official website.
- 2. Open Your Spreadsheet: Open your .xlsx or .xls file using WPS Spreadsheet.
- 3. Export to PDF: Go to the Menu and select 'Export to PDF'. Your colors will be retained perfectly.

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.




