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 that get sliced at the edge of the page, rows that disappear onto a second sheet with no indication they are there, 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 one 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 will attempt 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 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 area 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 rather than overflowing onto a second page. Excel's scaling options control this directly.

Go to Page Layout → Scale to Fit. You will see Width and Height dropdowns, both set to "Automatic" by default. Change Width to 1 page and leave Height on Automatic. This forces all columns to fit on a single page width regardless of how many there are, while letting the content flow naturally across as many rows (and therefore pages) as needed.

For spreadsheets that need to fit entirely on a single page — a one-page summary, a dashboard, a report cover — 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 than portrait. 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. Excel has a dedicated setting to repeat your header row at the top of every printed page.

Go to Page Layout → Print Titles. In the dialog box, click the field next to Rows to repeat at top and then 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

Here is a quick reference for the most useful page layout settings and where to find them:

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 in a single PDF, you need to select them all first.

Right-click any sheet tab at the bottom 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. Each sheet starts on a new page.

When to Use an Online Converter Instead

Excel's built-in export is the most precise option when you have control over the file and access to 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 and need to convert quickly without opening a desktop app.
• You received a spreadsheet and need a PDF of it without having Microsoft Excel installed.
• The file was sent by someone else and opening it in Excel would require accepting macros or adjusting security settings.
• You need to convert several files in a row and want a faster workflow than 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 inserted into cells, 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.

For most Excel PDFs being sent by email or uploaded to a portal, compression is not necessary — but it takes ten seconds and never hurts.