How to Convert Excel to PDF Without Formatting Issues (2026 Guide)

Why Excel to PDF Conversion Goes Wrong

Converting an Excel spreadsheet to PDF should be a simple task, but it consistently catches people by surprise. Columns get cut off at the right edge of the page. Rows that looked fine in Excel spill across multiple pages at awkward points. Charts appear on the wrong pages. Text that fitted perfectly in a cell is truncated in the PDF output. Colours shift. The carefully constructed layout you worked on for hours looks like a different document entirely.

These problems are not random. They all stem from the same fundamental mismatch: Excel is a grid-based application that does not think in pages, and PDF is a page-based format. When you convert from one to the other, that mismatch has to be resolved somehow, and if you do not resolve it deliberately, Excel makes its own choices which are often not what you wanted.

The good news is that all of these problems are preventable. This guide walks through the preparation steps that eliminate formatting issues before conversion, and the specific settings that control the output.

Step 1: Define Your Print Area

The print area is one of the most important and most ignored settings in Excel. When no print area is defined, Excel attempts to include all cells that contain data when converting to PDF. This often includes empty cells that Excel considers part of the used range, resulting in blank pages or extra columns that should not appear in the output.

To set the print area, select exactly the cells you want to appear in the PDF. Then go to Page Layout in the ribbon, click Print Area, and choose Set Print Area. A dashed border will appear around your selection confirming the area is set.

This single step eliminates the most common cause of unexpected blank pages and extra content in Excel PDF output.

Step 2: Set the Page Orientation and Size

Most Excel spreadsheets are wider than they are tall. Portrait orientation cuts columns off on the right. Switching to Landscape orientation in the Page Layout tab gives you significantly more horizontal space and usually solves the cut-off columns problem immediately.

Set the paper size to match what your recipients will print on. For most countries, A4 is standard. For US recipients, Letter size is the norm. Using the wrong paper size does not affect how the PDF looks on screen, but it causes formatting problems when the recipient tries to print.

Step 3: Use Scale to Fit

The Scale to Fit options in the Page Layout tab are specifically designed to resolve the problem of content overflowing the page. The most useful option is Fit All Columns on One Page, which shrinks the horizontal scale of your spreadsheet until all columns fit within the page width. Rows continue to break naturally across pages, but no columns are cut off.

If your spreadsheet has many rows as well as many columns, consider setting both dimensions: Fit Sheet on One Page forces everything onto a single page by shrinking as much as necessary. Be aware that if your spreadsheet is large, this can make the text very small. Always check the result in Print Preview before finalising.

Step 4: Repeat Header Rows on Every Page

For spreadsheets that span multiple pages, having column headers appear only on the first page makes the subsequent pages difficult to read. Excel can automatically repeat your header row at the top of every page in the PDF output.

Go to Page Layout and click Print Titles. In the Rows to repeat at top field, enter the reference for your header row. For example, enter dollar sign 1 colon dollar sign 1 to repeat row 1 on every page. This is a small setting that makes a significant difference to the readability of multi-page spreadsheet PDFs.

Step 5: Check Print Preview Before Exporting

This step is skipped more often than any other and accounts for most of the preventable formatting surprises. Before exporting to PDF, go to File then Print. This opens the print preview, which shows exactly what the PDF output will look like, page by page.

Scroll through every page and check: are all columns visible? Do headers repeat? Are charts on the right pages? Is any content truncated? Are there unexpected blank pages? Fixing problems in Print Preview takes a few seconds. Fixing them after sharing the PDF with a client takes much longer.

Step 6: Export Using Excel's Native Export Function

The most important choice in the entire process is how you create the PDF. Excel's native export function produces the highest quality and most accurate output because it uses Excel's own rendering engine, which understands all of Excel's page layout settings exactly.

Go to File, then Export, then Create PDF/XPS. In the dialog that opens, choose Standard quality for documents that will be printed, or Minimum size for documents that will only be read on screen. Click Publish to create the file.

Avoid the Print to PDF method (using a virtual PDF printer) for Excel files. This approach renders the spreadsheet through the operating system's print driver rather than Excel's own engine, which ignores some layout settings and produces lower quality results.

When to Use an Online Converter

Online converters like PDFTools are most useful when you need to convert an Excel file on a device that does not have Microsoft Excel installed. The Word to PDF Word to PDF tool at PDFTools accepts Excel files as well as Word documents and handles straightforward spreadsheets reliably. For complex spreadsheets with conditional formatting, pivot tables, or intricate layout rules, native Excel export is always the more accurate option.

Fixing Common Problems

Conclusion

Formatting problems in Excel to PDF conversion are almost always caused by settings that were never configured, not by the conversion tool itself. Setting the print area, choosing the right orientation, using Scale to Fit, repeating header rows, and checking Print Preview before export will eliminate the vast majority of issues before they occur.

For the export step, always use Excel's native Create PDF/XPS function rather than virtual printing. If you need to reduce the resulting file size for emailing, the compress PDF tool at PDFTools handles this quickly after export. For combining multiple spreadsheet PDFs into a single document, the merge PDF