PDF Conversion Issues

Fix Excel Cell Borders Disappearing When Saving as PDF

Anum MushtaqAnum Mushtaq Nov 22, 2026 868 views

Question details

The user needs to preserve Excel cell borders when converting a workbook to PDF.

Fix Excel Cell Borders Disappearing When Saving as PDF
Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook contains rows copied into an existing print area and is saved or printed as a PDF.
Observed behavior
Some cell borders disappear in the PDF with both Save as PDF and a PDF printer, although newly created workbooks may export correctly.
Before you start

Identify the affected cells and check whether their lines are actual borders or worksheet gridlines. In Excel, select the cells and use Home > Borders to inspect or apply borders before testing the export.

Solution 1Recommended

Test a local copy and compare it with a new workbook

Use this test to narrow down whether the missing borders are tied to the workbook, its SharePoint location, or the PDF export process.

1
Save a local test copy

Open the affected workbook in Excel and use File > Save As to save a copy on your device. Leave the original SharePoint file unchanged so its revision history is preserved.

2
Export the local copy

Use File > Save As or File > Export to create a PDF from the local copy. Open the PDF and inspect the affected borders, including at a higher zoom level.

3
Test a new workbook

Create a new workbook in Excel, enter the same information in a similar layout, and apply the required borders using Home > Borders. Save it locally and export it to PDF.

4
Compare the results

Compare the PDFs from the SharePoint workbook, the local copy, and the new workbook. If only the original workbook and its local copy have missing borders, inspect their template or formatting; if both local files fail, investigate Excel or the PDF conversion process.

Test a local copy and compare it with a new workbook
Interpreting the test: A local copy retains the original workbook's formatting, so it does not by itself rule out a template or formatting issue. A separately created workbook provides an additional comparison.
Free Microsoft Office alternative

Export spreadsheets to PDF with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open your Excel workbook in WPS Spreadsheets and try exporting it to PDF; check the resulting borders, since changing applications may not resolve every workbook-specific formatting issue.

Export spreadsheets to PDF and inspect cell bordersCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet tools for an easier transition from ExcelFree and lightweight for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Why do borders disappear with both Save as PDF and a PDF printer?

Both methods can be affected by the workbook's formatting or print layout. Test a local copy and a separately created workbook to see whether the issue follows the original file.

How can I tell whether the missing lines are borders or gridlines?

Select the cells and check Home > Borders. Gridlines are worksheet guides rather than applied borders; to print them, enable Page Layout > Sheet Options > Gridlines > Print.

Can the print area exclude the rows with missing borders?

Yes. Select the full range you want in the PDF and choose Page Layout > Print Area > Set Print Area, then check the layout under File > Print.

Should I edit the original SharePoint workbook while testing?

For testing, use File > Save As to create a local copy. This keeps the original SharePoint file and its revision history intact while you compare exports and rebuild formatting.