How to Keep Excel Cell Colors When Saving or Printing to PDF
Question details
The user needs to preserve cell background colors when converting an Excel spreadsheet into a PDF document.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing or exporting a formatted Excel workbook to a PDF file.
- Observed behavior
- Colored cells display correctly in Print Preview, but the resulting PDF file appears in grayscale or black and white, despite workbook print settings being correctly configured.
Verify that your PDF viewer is not set to display documents in high contrast mode, and confirm that your printer drivers are up to date.
Use the Built-in Save As or Export Feature
Using Excel's native PDF export function bypasses third-party printer driver settings that might strip away colors.
When you use a virtual PDF printer, the software acts as an intermediary and applies its own print rules, which can sometimes default to grayscale. Using the native export tools ensures the data is directly translated into a PDF with all styling retained.
Click on the 'File' tab in the top-left corner of the window and select 'Save As' or 'Export'.
If using 'Save As', choose the destination folder, then click the 'Save as type' dropdown menu and select 'PDF (*.pdf)'. If using 'Export', click 'Create PDF/XPS Document'.
Click the 'Save' or 'Publish' button to generate the PDF file with all original cell colors perfectly preserved.
Adjust PDF Printer Color Settings
If you must use a PDF printer like Adobe PDF, ensure its properties are not set to output in monochrome or grayscale.
Easily Export Spreadsheets to Colorful PDFs with WPS Office
WPS Office provides a native, highly accurate PDF export feature that seamlessly preserves your spreadsheet's cell colors, charts, and formatting without relying on complicated printer driver settings.
- 1. Open your file: Launch WPS Office and open the spreadsheet containing your colored cells.
- 2. Access the Export tool: Click on the 'Tools' tab at the top of the interface, then select 'Export to PDF'.
- 3. Adjust export settings: In the pop-up dialog, verify your page ranges and ensure the export options are configured to include all formatting.
- 4. Generate the PDF: Click the 'Export' button to instantly create a PDF document that retains all of your cell colors and styles.
Frequently Asked Questions
Why does my Excel to PDF conversion lose colors even when 'Black and White' is unchecked in Page Setup?
This typically occurs because the third-party PDF printer driver (such as Adobe PDF) overrides Excel's page setup and defaults to a grayscale or monochrome output setting in its own printer properties.
Can conditional formatting colors be preserved when saving to PDF?
Yes, conditional formatting colors are preserved automatically as long as you use the native 'Save As' or 'Export to PDF' function in your spreadsheet software, rather than printing through a virtual monochrome printer.
How do I check if my PDF viewer is causing the missing colors?
Open the generated PDF file in a different application, such as a web browser. If the colors display correctly in the browser, your PDF viewer's accessibility or high-contrast settings are likely hiding the colors.
