'%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 Thick Lines When Exporting Excel to PDF
Question details
The user needs to correct the issue of cell border lines appearing unusually thick when saving or exporting a spreadsheet as a PDF document.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Exporting an Excel worksheet to a PDF format for sharing or printing.
- Observed behavior
- The resulting PDF document displays gridlines or cell borders that are significantly thicker and bolder than they appear in the original Excel worksheet.
Use the Print Preview feature in Excel to verify the appearance of your borders before performing the actual PDF export, as this preview often reflects how the final document will render.
Adjust Cell Border Formatting
Reconfigure the border thickness settings within the worksheet formatting options to ensure the correct line styles are applied during the PDF export.
Unexpectedly thick lines in an exported PDF are frequently caused by incorrect or conflicting border styles applied within the Excel worksheet. Manually resetting these borders to a thinner style can resolve the rendering issue.
Highlight the range of cells in your Excel worksheet that are displaying overly thick lines in the exported PDF.
Navigate to the 'Home' tab on the top ribbon. In the 'Font' group, click the drop-down arrow next to the 'Borders' icon.
Scroll to the bottom of the drop-down menu and select 'More Borders...' to open the Format Cells dialog box.
In the 'Style' section on the left, select a thinner continuous line. Click the 'Outline' and 'Inside' presets, or click directly on the preview area to apply the new border thickness, then click 'OK'.
Go to 'File' > 'Export' > 'Create PDF/XPS Document' and export the worksheet again to verify that the lines are now the correct thickness.
Use WPS Spreadsheet for Perfect PDF Conversion
WPS Office offers a built-in, highly optimized PDF export engine that accurately preserves your spreadsheet's formatting, including exact border line thickness without unexpected rendering bugs.
- 1. Open Your Spreadsheet in WPS Office: Launch WPS Office and open your existing Excel (.xlsx) worksheet.
- 2. Verify Border Settings: Select your cells, go to the 'Home' tab, and use the Borders tool to ensure your desired line style is applied.
- 3. Export to PDF Directly: Click 'Menu' in the top-left corner, select 'Export to PDF', configure your export preferences, and choose your preferred saving location.
Frequently Asked Questions
Why do normal Excel borders appear thick in a PDF?
This happens due to the way different PDF renderers interpret Excel's default border weights. Sometimes a standard line is scaled up during conversion, requiring you to explicitly select a thinner line style in the Format Cells menu.
Does the PDF viewer affect line thickness?
Yes, some PDF viewing applications have 'Enhance thin lines' settings enabled by default. Disabling this setting in your PDF reader's preferences can sometimes make the borders look normal without requiring changes to the Excel file.
Can I remove all borders before exporting to fix this?
Yes. If visible borders are not absolutely necessary, you can highlight all cells, click the Borders drop-down on the Home tab, and select 'No Border' before performing the PDF export.
Will changing the print quality affect the PDF lines?
Changing the print resolution (DPI) in the Page Setup menu can sometimes alter how lines are rendered. Setting it to a standard resolution (like 600 DPI) often yields more consistent PDF export results.
