Printing Problems

How to Fix Excel Borders Missing or Not Printing

John Wilson Oct 9, 2026 871 views

Question details

Users need to resolve an issue where applied cell borders do not show up when editing, previewing, or printing a worksheet.

How to Fix Excel Borders Missing or Not Printing

Product: Microsoft Excel
Device & OS: Windows, macOS
Scenario: Formatting a worksheet with thick cell borders and attempting to print the document.
Observed behavior: Thick cell borders display inconsistently or are completely missing in the worksheet editing view, the print preview, and the final printed output.

Before you start

Ensure your printer drivers are up to date and check your printer's ink levels, as missing printed borders can sometimes be caused by basic hardware miscommunications or driver bugs.

Solution 1Recommended

Verify Border Formatting and Print Preview

Check that the borders are correctly applied to the exact cell range and verify their visibility using the print preview feature.

Sometimes borders are applied to adjacent cells that are excluded from the current print area, or the applied line style is too thin to render correctly on certain printers.

Select the target cells

Highlight the specific cell range where you want the borders to appear.

Reapply thick borders

Right-click the selection, choose 'Format Cells', navigate to the 'Border' tab, select a thicker line style, and apply it to the outline and inside of the cells.

Check Print Preview

Go to File > Print to open the print preview. Check if the thick borders are now visible in the preview window.

Verify Border Formatting and Print Preview

Print Area Settings: Ensure that your configured Print Area includes the outer edges of the cells where the borders are applied.

Solution 2

Export the Worksheet as a PDF

Exporting your Excel file to a PDF helps isolate whether the issue is caused by Excel's rendering engine or your specific printer settings.

Solution 3

Adjust Print Quality and Scaling Options

Draft quality settings or aggressive page scaling can cause Excel to drop visual elements like borders to save ink or fit the page.

Print Spreadsheets Perfectly with WPS Office

WPS Spreadsheet provides a seamless and reliable printing experience, ensuring that cell borders and formatting appear exactly as expected without rendering issues.

1. Open your Workbook: Launch WPS Office and open your spreadsheet file.
2. Apply Borders: Select the desired cells and apply thick borders directly from the Home tab.
3. Preview the Document: Click the Print Preview icon to confirm that all borders are accurately displayed.
4. Print Document: Click Print to send the accurately rendered document to your printer.

Reliable print rendering for thick borders and custom formattingHighly compatible with Microsoft Excel (.xlsx) file formatsAccurate print preview that matches the final paper outputFree, lightweight, and features an intuitive interface

microsoft office alternative - wps office

Frequently Asked Questions

Why are my cell borders showing on screen but not on paper?

This discrepancy is often caused by outdated printer drivers, incorrect print scaling settings, or having the 'Draft quality' print setting enabled, which strips out formatting to save ink.

Does saving the spreadsheet as a PDF fix missing borders?

Yes, exporting your worksheet as a PDF forces the software to render all cell formatting into a fixed layout. You can then print the PDF directly, which frequently bypasses application-specific or printer-specific rendering bugs.

How do I ensure thick borders print correctly at the edge of a page?

If borders are placed on the very edge of the printable area, they might be cropped by your printer's hardware margins. You can fix this by adjusting your page margins slightly inward in the Page Setup menu.

Document & File Issues