You can see cell borders on your Excel worksheet, but they disappear when you print the page or create a PDF. This happens because Excel has separate settings for screen display and print output. The print driver or a specific page setup option often filters out thin borders. This article explains why borders vanish and provides steps to make them print correctly.
Key Takeaways: Fixing Excel Border Printing Issues
- Page Layout > Page Setup > Sheet > Draft Quality: Disabling this setting ensures all cell formatting, including borders, is included in the print job.
- Page Layout > Scale to Fit > Width/Height boxes: Setting these to ‘1 page’ prevents scaling from making borders too thin to print.
- File > Print > Page Setup > Sheet > Black and white: Unchecking this option stops colored borders from being omitted in grayscale printouts.
Why Excel Borders Appear On Screen But Not On Paper
Excel manages screen display and print output through different rendering engines. What you see on your monitor is drawn by Windows and your graphics card. The printed page is rendered by a combination of Excel’s print engine and your printer driver. A common cause is the ‘Draft Quality’ print setting, which speeds up printing by omitting most cell borders and graphics. Another frequent issue is page scaling. If you scale a sheet to fit on one page, very thin border lines can become sub-pixel in width and are dropped from the print data. Printer drivers also have settings that may ignore light gray or colored lines if the print mode is set to ‘Black and white’ or ‘Fast draft’.
Steps to Make Cell Borders Print Correctly
Follow these steps in order to diagnose and fix the most common border printing problems.
- Check the ‘Draft Quality’ Setting
Go to the Page Layout tab. Click the small dialog launcher in the bottom-right corner of the Page Setup group. In the Page Setup dialog, go to the Sheet tab. Look for the ‘Draft quality’ checkbox under the Print section. If it is checked, uncheck it and click OK. This setting is often enabled for large workbooks to save ink, but it removes borders. - Adjust Page Scaling Settings
On the Page Layout tab, find the Scale to Fit group. Look at the ‘Width’ and ‘Height’ boxes. If they are set to ‘Automatic’ or a value like ‘Fit sheet on one page’, Excel will shrink the content. This can make borders too thin. Set both boxes back to ‘Automatic’ or explicitly set the ‘Scale’ percentage to 100%. - Verify Print Color Settings
Click File > Print. On the print settings screen, click ‘Page Setup’ at the bottom. In the Page Setup dialog, go to the Sheet tab. Find the ‘Black and white’ checkbox. If it is checked, uncheck it. This setting tells Excel to ignore colored cell borders, which may include light gray ones you intended to print. - Make Borders Thicker and Darker
Select the cells with missing borders. On the Home tab, in the Font group, click the border icon dropdown. Choose ‘Line Color’ and select solid black. Then, click the border icon again, go to ‘Line Style’, and choose a thicker style, like the second option. Finally, apply the border again using the ‘All Borders’ or ‘Outside Borders’ option. - Use the Print Preview Feature
Always check File > Print to see the print preview before sending the job. The preview pane shows exactly what will be sent to the printer. If borders are missing here, the problem is in Excel’s page setup. If borders appear in the preview but not on the physical paper, the issue is likely with your printer driver settings.
If Borders Still Do Not Print
After trying the core steps, some specific scenarios require further action.
Borders Print on Some Printers But Not Others
This points to a printer driver issue. Open Windows Settings and go to Devices > Printers & scanners. Select your printer and click ‘Manage’. Choose ‘Printing preferences’. Look for a ‘Quality’ or ‘Mode’ tab and change the setting from ‘Draft’ or ‘Economy’ to ‘Normal’ or ‘Best’. Also, look for an ‘Advanced’ button and check for settings related to printing graphics or line weights.
Borders Disappear Only in PDF Export
When using File > Save As or Export to create a PDF, the problem may be in the PDF creation settings. In the Save As dialog, after choosing PDF, click the ‘Options’ button. In the Options dialog, ensure ‘ISO 19005-1 compliant (PDF/A)’ is NOT checked. This compliance mode can sometimes alter graphical elements. Also, under ‘Publish what’, make sure ‘Entire workbook’ is selected if your borders are on a hidden sheet.
Borders Are Missing From Copied Ranges in Print
If you paste a range of cells as a picture or linked object, the borders may not be part of the copied format. Instead of copying and pasting, try setting the print area directly. Select the cells you want to print, go to the Page Layout tab, and click Print Area > Set Print Area. This tells Excel to print the original cells with their native formatting.
Screen Display vs Print Output: Key Differences
| Item | Screen Display | Print Output |
|---|---|---|
| Rendering Engine | Windows graphics subsystem | Excel print engine and printer driver |
| Minimum Line Weight | Can display sub-pixel lines | Lines below a certain thickness are ignored |
| Color Handling | Shows all colors as defined | May convert colors to grayscale or omit them |
| Draft Quality Setting | Has no effect | When enabled, removes borders and graphics |
| Page Scaling Impact | Dynamically adjusts on screen | Permanent reduction can delete thin borders |
You can now ensure your Excel borders print reliably every time. Always use the Print Preview to confirm the output before finalizing a report. For advanced control, explore the ‘Format Cells’ dialog box to set custom border styles that are less likely to be filtered out. Remember that setting the print area is more reliable than copying cells as an image for printing.