Printing Problems

Fix Excel Borders Missing When Printing or Saving to PDF

Huma Ashraf ChHuma Ashraf Ch Nov 12, 2026 870 views

Question details

The user needs Excel cell borders to remain visible when printing a worksheet or exporting it as a PDF.

Fix Excel Borders Missing When Printing or Saving to PDF
Product
Microsoft Excel
Device & OS
not provided
Scenario
Cell borders and gridlines look correct in the worksheet and Print Preview before the user prints or creates a PDF.
Observed behavior
Borders disappear from the final printed document or exported PDF, even though they appear in Excel.
Before you start

Open the affected worksheet and confirm that the missing lines are manually applied cell borders rather than only worksheet gridlines. Use the same worksheet and print area that produces the missing-border result.

Solution 1Recommended

Turn off the Black and white worksheet print option in Excel

Use this solution when borders appear in Excel or Print Preview but are omitted from the printed output or PDF.

The Black and white print setting can suppress color and formatting details during printing and PDF creation. Clearing it allows applied cell borders to print normally.

1
Open Page Setup

In Excel, open the affected worksheet, select the Page Layout tab, and click the small Page Setup dialog launcher in the lower-right corner of the Page Setup group.

2
Open the Sheet settings

In the Page Setup dialog box, select the Sheet tab to view worksheet-specific printing options.

3
Clear Black and white

Under Print, clear the Black and white check box, then select OK to save the setting.

4
Print or export the worksheet again

Go to File > Print to print the sheet, or use File > Save As or Export > Create PDF/XPS to create a new PDF and verify that the borders appear.

Turn off the Black and white worksheet print option in Excel
Borders should be restored: After Black and white is turned off, manually applied borders should be retained in both printed pages and newly generated PDFs.
Print worksheets accurately with WPS Office

Keep spreadsheet borders visible when printing or exporting with WPS Spreadsheets

WPS Spreadsheets lets you review worksheet print settings, disable black-and-white output, and export a spreadsheet to PDF while preserving applied cell borders and formatting.

  1. 1. Open the spreadsheet: Open the Excel workbook in WPS Spreadsheets and select the worksheet with missing borders.
  2. 2. Open print settings: Click Page Layout and open the worksheet print or page setup options.
  3. 3. Disable black-and-white output: Clear the Black and white print option if it is selected, then confirm the setting.
  4. 4. Review the print preview: Click Menu > Print and check that the cell borders appear in the preview.
  5. 5. Create the PDF: In the Print window, choose a PDF printer or use Menu > Export to PDF to generate the file.
Control black-and-white and worksheet print options before printing.Preview borders and page layout before creating a PDF.Open and save Microsoft Excel .xlsx and .xls files with formatting compatibility.Export spreadsheets to PDF from a familiar, lightweight office interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel borders show on screen but not in my PDF?

A worksheet print setting, especially Black and white, can suppress formatting during PDF creation. Open Page Layout > Page Setup > Sheet and clear Black and white, then export the PDF again.

Are Excel gridlines the same as cell borders when printing?

No. Gridlines are worksheet guides and do not print unless Page Layout > Gridlines > Print is enabled. Cell borders are formatting applied through Home > Borders and normally print without enabling gridlines.

Where is the Black and white option in Excel?

Select Page Layout, click the Page Setup dialog launcher, open the Sheet tab, and look under Print. Clear the Black and white check box.

What should I do if the border still does not print after disabling Black and white?

Select the affected cells and choose Home > Borders > More Borders. Apply a darker color or thicker line style, then check File > Print before printing or exporting again.

Will changing the Black and white setting affect every worksheet in my workbook?

The Page Setup setting is typically configured per worksheet. Check the Sheet tab in Page Setup for each worksheet that has missing borders.