Printing Problems

How to Export an Excel Worksheet to PDF Without Visible Borders

Nimra MalikNimra Malik Nov 11, 2026 868 views

Question details

The user wants to export an Excel worksheet as a PDF file without any white edges or visible borders around the content.

Export an Excel Worksheet to PDF Without Visible Borders
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Page Setup

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.

2
Set Margins to Zero

Navigate to the 'Margins' tab in the dialog box. Change the Top, Bottom, Left, Right, Header, and Footer values all to 0.

3
Center the Content

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.

4
Export to PDF

Go to 'File' > 'Export' > 'Create PDF/XPS Document', select your file location, ensure 'Standard' optimization is checked, and click 'Publish'.

Adjust Page Setup Margins to Zero Manually
Printer Driver Limitations: Even with zero margins, true borderless output might be restricted if your active printer driver enforces a non-printable hardware margin. Using 'Microsoft Print to PDF' or the built-in 'Export' function yields the best results.
Seamless PDF Export in WPS Office

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. 1. Open Your Spreadsheet: Launch WPS Spreadsheet and open the document you wish to export.
  2. 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. 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.
Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Built-in PDF conversion tool with advanced layout and margin controls.Free to use with a lightweight, intuitive, and familiar interface.Cross-platform support for Windows, Mac, Linux, and mobile devices.
microsoft office alternative - wps office

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.