Fix Missing Conditional Formatting Borders When Printing Excel Files
Question details
The user needs to resolve an issue where conditional formatting borders disappear during the printing process or when exporting the file to PDF.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing an Excel spreadsheet to a physical printer or exporting the worksheet as a PDF document.
- Observed behavior
- Conditional formatting borders are fully visible in the Excel Print Preview but fail to appear on the final printed paper or in the generated PDF file.
Verify that standard cell borders print correctly. If only the conditional formatting borders are missing, the issue is likely tied to Excel's internal graphics rendering settings rather than a generalized printer hardware failure.
Enable High Quality Mode for Graphics in Excel Options
Adjusting Excel's advanced print settings forces the software to render conditional formatting graphics at a higher quality, ensuring they are not dropped during the spooling process for paper or PDF.
Excel sometimes attempts to optimize print jobs by lowering the quality of graphical overlays, which includes conditional formatting borders. Forcing high-quality rendering usually resolves the issue.
Click on 'File' in the top-left corner of the Excel ribbon, then select 'Options' at the bottom of the menu to open the Excel Options dialog box.
Click on the 'Advanced' tab located in the left-hand sidebar of the Options window.
Scroll down the list until you find the 'Print' section. Check the box labeled 'High quality mode for graphics'.
Click 'OK' at the bottom of the window to apply your new settings.
Test a Different PDF Printer and Update Drivers
If changing Excel's internal settings doesn't work, the problem may be caused by an outdated printer driver or a glitchy virtual PDF printer.
Experience Reliable Spreadsheet Printing with WPS Office
If Excel continues to drop formatting during printing or PDF exports, consider switching to WPS Office. It provides precise print rendering, ensuring that the conditional formatting you see on your screen translates flawlessly to paper and PDFs.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Excel file. All conditional formatting rules will be instantly preserved.
- 3. Print Without Errors: Press Ctrl + P to print. Enjoy perfectly rendered borders, graphics, and formatting on your final documents.
Frequently Asked Questions
Why do regular cell borders print fine, but conditional formatting borders disappear?
Excel treats conditional formatting borders as graphical overlays rather than standard spreadsheet gridlines. If your print quality settings or printer drivers struggle with processing complex graphics, these specific overlays may fail to render during the print process.
Does saving as a PDF instead of 'printing to PDF' fix the missing borders?
Sometimes using the 'Save As' > PDF method bypasses the printer driver entirely, which can successfully preserve the borders. However, if the root issue stems from Excel's internal graphics rendering, you will still need to enable 'High quality mode for graphics' in the options.
Can a corrupted Excel workbook cause conditional formatting to not print?
Yes, corruption within the spreadsheet's formatting rules can cause unexpected rendering issues. If adjusting settings does not work, try clearing the conditional formatting rules and recreating them, or copy the data to a fresh workbook.
