How to Convert Excel to PDF and Keep Your Formatting

Why Excel to PDF Is More Complicated Than Word to PDF

Converting a Word document to PDF is usually seamless — what you see in Word is what you get in the PDF. Excel is different. A spreadsheet is not a page-based document. It is a potentially infinite grid, and turning that grid into a fixed-size page requires a set of decisions that Excel, your PDF tool, or both will make on your behalf — often badly.

The result is a familiar set of frustrations: columns sliced at the page edge, rows disappearing onto a second sheet with no indication, gridlines that vanish, header rows that only appear on the first page, or a tiny table floating in the middle of a vast white page because the print area was never defined.

None of these problems are random. Each has a specific cause and a specific fix. Once you understand why they happen, getting a clean PDF from any spreadsheet takes under two minutes.

The Most Common Problems and How to Fix Each One

Step One: Define Your Print Area

The single most impactful thing you can do before converting any spreadsheet to PDF is to define a print area. By default, Excel attempts to print the entire used range of the sheet — which often includes empty columns or rows far beyond your actual data, causing the PDF to include blank pages or push content off the page edge.

• 1
  Select the exact range of cells you want in the PDF — from the top-left of your data to the bottom-right, including headers.
• 2
  Go to Page Layout → Print Area → Set Print Area. A dashed border will appear around your selection confirming it is set.
• 3
  If you have multiple separate tables on one sheet that should all appear in the PDF, hold Ctrl while selecting each range before setting the print area.

Once the print area is defined, only that range will appear in the PDF. Blank rows or stray content outside the selection are ignored completely.

Step Two: Fit Your Data to the Page

After defining the print area, the next step is making sure your columns fit within the page width. Go to Page Layout → Scale to Fit. Change Width to 1 page and leave Height on Automatic. This forces all columns to fit on a single page width, while letting content flow naturally across as many rows as needed.

For spreadsheets that need to fit entirely on a single page — a one-page summary or dashboard — set both Width and Height to 1 page. Everything will scale down to fit on one sheet of paper.

Step Three: Set the Right Page Orientation

Most spreadsheets are wider than they are tall, which means landscape orientation usually produces a better PDF. Go to Page Layout → Orientation → Landscape for any sheet that has more columns than rows, or any data that would otherwise get cut off in portrait mode.

Portrait works well for narrow tables — typically those with fewer than six or seven columns — especially if the data has many rows that need to be read sequentially like a transaction log or a contact list.

Step Four: Repeat Headers on Every Page

A multi-page PDF with column headers only on the first page is nearly impossible to read. Go to Page Layout → Print Titles. In the dialog, click the field next to Rows to repeat at top and click the row number of your header row in the spreadsheet (usually row 1). The reference will appear as $1:$1. Click OK. Every page of your PDF will now start with the column headers.

Step Five: Choose Your Conversion Method

Once the sheet is configured correctly, you have several reliable ways to convert it to PDF.

Excel PDF Settings Reference

Converting Multiple Sheets at Once

By default, Excel only converts the active sheet to PDF. If your workbook has multiple sheets that all need to be included, right-click any sheet tab and choose Select All Sheets, or hold Ctrl and click each tab you want to include. Then go to File → Export → Create PDF/XPS. All selected sheets will be combined into one PDF in tab order, with each sheet starting on a new page.

When to Use an Online Converter Instead

Excel’s built-in export is the most precise option when you have the desktop application. But there are situations where an online converter like Convixy Excel to PDF is the better choice: you are on a phone or tablet, you received a spreadsheet and do not have Excel installed, or you need to convert several files quickly without opening each in Excel individually.

Online conversion handles standard XLSX and XLS files reliably for most use cases. For complex workbooks with custom VBA, advanced charts, or pivot tables with heavy formatting dependencies, the desktop export will always give more accurate results.

After Converting: Should You Compress the PDF?

Spreadsheets converted to PDF are usually small — a few hundred kilobytes for a typical data table. The exception is workbooks that contain embedded charts with many data points, high-resolution images, or dozens of sheets. If your Excel PDF is unexpectedly large, running it through a PDF compressor can reduce the file size significantly without affecting the text or table content at all.