'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Borders Printing Incorrectly or Missing in PDF Exports
Question details
The user is experiencing issues where cell borders have incorrect thickness, disappear in PDF exports, or fail to show up in repeating header rows.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to physically print a worksheet or export it to a PDF file while preserving precise cell borders and repeating header lines.
- Observed behavior
- Borders render with the wrong thickness, go missing completely in the resulting PDF, or fail to appear on repeating top rows across multiple pages.
Before proceeding, check the Print Preview in your spreadsheet software to determine if the missing borders are a layout issue or caused by the physical printer settings.
Adjust Page Setup and Scaling Settings
Improper page scaling can cause thin borders to shrink into invisibility during PDF export or printing. Adjusting scaling ensures lines render at the correct size.
When you shrink a large worksheet to fit onto a single page, fine visual elements like cell borders can become too thin for the PDF rendering engine to display.
Navigate to the 'Page Layout' tab on the top ribbon and click the small dialog box launcher arrow in the bottom right corner of the 'Page Setup' group.
Under the 'Page' tab, look at the 'Scaling' section. If it is set to a very low percentage under 'Adjust to' or 'Fit to', try increasing the scale closer to 100%.
Go to the 'Sheet' tab within the same dialog and ensure that the 'Print Area' fully encompasses all your bordered cells, without cutting them off at the margins.
Reapply Thicker Border Styles
Hairline or very thin borders are known to drop out during the PDF conversion process. Applying a standard or thicker line style can fix visibility problems.
Use an Alternative PDF Printer
The built-in 'Save As PDF' feature sometimes struggles with specific cell formatting. Using a virtual PDF printer can process graphics differently and yield better results.
Easily Print and Export Spreadsheets to PDF with WPS Office
WPS Spreadsheet offers high-quality, native PDF export capabilities, ensuring that your custom cell borders, repeating headers, and precise page setups print exactly as they appear on your screen.
- 1. Open Your Spreadsheet: Launch WPS Office and open your .xlsx file containing the bordered cells.
- 2. Check Print Preview: Click the 'Print Preview' icon in the quick access toolbar to ensure borders display correctly.
- 3. Export to PDF: Go to the main 'Menu' and click 'Export to PDF'.
- 4. Save Your Document: Choose your export range, configure the save path, and click 'Export' to generate a flawless PDF.
Frequently Asked Questions
Why do my Excel borders disappear when saving as PDF?
This commonly happens because of page scaling constraints or because the border line style is set to a hairline width. Some PDF rendering engines fail to draw very thin lines. Choosing a thicker border style usually resolves this.
How do I fix missing borders in repeating header rows?
Go to Page Setup > Sheet tab, and ensure your 'Rows to repeat at top' are correctly selected. Re-applying the border specifically to that header row range rather than the whole table can resolve export glitches on subsequent pages.
Does 'Print to PDF' work better than 'Save as PDF'?
In many scenarios, yes. Using a virtual printer like 'Microsoft Print to PDF' processes page graphics differently than the built-in 'Save As PDF' exporter, which often correctly renders stubborn cell formatting and borders.
Can print area settings affect border visibility?
Yes. If a border sits exactly on the edge of your defined print area or page margin, it might get truncated during printing or PDF export. Try expanding the print area by one column/row or slightly reducing the page margins.
