Fix Excel Cell Borders Disappearing When Saving as PDF
Question details
The user needs to preserve Excel cell borders when converting a workbook to 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.
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.
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.
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.
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.
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.
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.

Rebuild the affected borders and print area
Use this approach when the test points to formatting or layout in the affected workbook.
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.

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.




