How to Export an Excel Worksheet to PDF Without Visible Borders
Question details
The user wants to export an Excel worksheet as a PDF file without any white edges or visible borders around the content.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Exporting a spreadsheet to a PDF document while maintaining a full-bleed or edge-to-edge appearance without default white margins.
- Observed behavior
- The PDF output displays unwanted white edges or borders even when Excel margins are set to zero, often caused by page setup settings or printer driver limitations.
Ensure that your worksheet content does not have cell borders applied to the outermost cells, and check your default printer settings, as some printer drivers enforce a minimum non-printable margin regardless of Excel settings.
Adjust Page Setup Margins to Zero Manually
Configure the page layout settings to remove all margins and center the content before exporting to ensure a borderless PDF.
Excel adds default margins to all printed and exported documents. By setting these margins to zero and utilizing the built-in PDF export feature, you can minimize or eliminate unwanted white borders.
Go to the 'Page Layout' tab on the ribbon and click the small diagonal arrow (dialog box launcher) in the bottom-right corner of the 'Page Setup' group.
Navigate to the 'Margins' tab in the dialog box. Change the Top, Bottom, Left, Right, Header, and Footer values all to 0.
Still in the 'Margins' tab, look under 'Center on page' and check both 'Horizontally' and 'Vertically' to ensure the data is perfectly aligned in the resulting PDF.
Go to 'File' > 'Export' > 'Create PDF/XPS Document', select your file location, ensure 'Standard' optimization is checked, and click 'Publish'.

Use a VBA Macro for Borderless Export
Automate the margin adjustment and PDF export process using a VBA script to guarantee consistent borderless output.
Export Spreadsheets to PDF Seamlessly with WPS Office
WPS Office provides a built-in, highly customizable PDF export tool that makes it easy to save your spreadsheets exactly as they appear on screen. You can effortlessly adjust margins, print areas, and scaling without needing external plugins or complex VBA scripts.
- 1. Open Your Spreadsheet: Launch WPS Spreadsheet and open the document you wish to export.
- 2. Adjust Page Layout: Navigate to the 'Page Layout' tab, open the Page Setup dialog, and set all margins (Top, Bottom, Left, Right) to 0.
- 3. Export to PDF: Click on 'Menu' in the top-left corner, go to 'Export to PDF', configure your layout settings to ensure no borders, and save the file.

Frequently Asked Questions
Why does my PDF still have a white border even with zero margins?
This is often caused by the selected printer driver or PDF renderer. Many printer drivers enforce a 'hard margin' or non-printable area. To fix this, try using the native 'Export to PDF' feature rather than the 'Print to PDF' option.
Can cell borders cause visible edges in the exported PDF?
Yes. If the outermost cells in your print area have borders applied, they will appear at the extreme edges of the PDF. Ensure you clear cell formatting from the perimeter if you want a completely clean edge.
How do I ensure my spreadsheet fits one PDF page without borders?
In the Page Setup dialog, under the 'Page' tab, select 'Fit to 1 page(s) wide by 1 tall'. Combine this setting with zero margins to force your content to scale to the very edges of the page.
Does the paper size affect the borderless PDF output?
Absolutely. If the aspect ratio of your print area does not match the selected paper size (e.g., A4 or Letter), the PDF will generate white space to fill the gap. You must match the paper size precisely to your content's dimensions for true borderless results.




