Excel to PDF: Why Tables Get Chopped (and the 5 Settings That Fix It)

You finish a quarterly report in Excel. The numbers are color-coded, the headers are bold, conditional formatting flags variances. You hit Print to PDF, attach the file, send. Then page 2 has no headers, columns 7 through 11 are cut off, and the chart on the summary tab is unreadable.

Every problem in that PDF has a fix that takes about 15 seconds. The fixes live in one menu (Page Layout, Page Setup) that most people never open. Here is the quick checklist, the symptom-to-fix map, and then the five settings explained in detail.

Quick Fix Checklist

If you only have a minute, do these three things in this order:

1. Page Layout → Orientation: Landscape — most spreadsheets are wider than tall.
2. Page Layout → Scale to Fit → Width: 1 page — forces all columns onto one page width.
3. Page Layout → Print Titles → Rows to repeat at top — pick your header row so it repeats on every page.

That combination resolves most layout complaints on its own.

Symptom-to-Setting Map

Setting 1: Scale to Fit

The most common failure: a table is one or two columns too wide, so Excel pushes the last columns onto a separate page sequence after the main report. Recipients see the data twice, partially, in awkward strips.

The fix lives in Page Layout, in the Scale to Fit group:

• Width: 1 page — force all columns onto one page width, scaling text down as needed.
• Height: Automatic — let Excel paginate vertically. Setting height to a number can compress data into illegible type.

Combine with Page Layout → Orientation: Landscape if your table is genuinely wide. Excel applies a uniform scaling factor (visible as a percentage in the same group) so everything fits on one page width. Text gets smaller. The structure stays.

Setting 2: Print Titles

Page 1 has your column headers. Page 2 starts with raw data and no labels. The reader has to flip back to remember what column 5 is.

Page Layout → Print Titles. Two fields:

• Rows to repeat at top — click the small arrow, click your header row in the sheet (usually row 1, sometimes rows 1 through 3 for multi-row headers). The field fills with $1:$1 or similar.
• Columns to repeat at left — for wide reports where column A holds row labels (account names, product names). Same idea, click column A.

Every page in the PDF then shows the same header row and (optionally) the same row labels at the left. The setting is per-sheet, so set it on every sheet you plan to export.

Setting 3: Print Area

You inherit a workbook. You export to PDF. The output has weird empty rows at the bottom or trims off your last column. The cause is usually a leftover Print Area set to a smaller range than your actual data.

Page Layout → Print Area gives you two options:

• Set Print Area after selecting cells, to limit the export to a specific section.
• Clear Print Area to remove an old setting and let Excel print everything.

If you are not deliberately limiting the export, Clear Print Area solves the “last column missing” complaint immediately.

Setting 4: Save As PDF, Not Print to PDF

Microsoft Excel has two routes to PDF, and they produce different output.

Print to PDF (File → Print → Microsoft Print to PDF) treats the workbook like a printed page going to a virtual printer. Charts come through at screen resolution. Vector elements get rasterized.

Save As PDF (File → Save As → PDF, or File → Export → Create PDF/XPS Document) uses Excel's native PDF engine. Charts come through as vector graphics. Text is searchable. The file is usually smaller. Quality is noticeably better.

Inside the Save As PDF dialog, click Options. Three settings worth knowing:

• Active sheet(s) vs Entire workbook vs Selection — default is active sheet only. To export all sheets in one PDF, choose Entire workbook.
• Standard vs Minimum size — Standard preserves quality. Minimum size compresses heavily.
• Document properties — embeds author and creation metadata. Uncheck if you want a clean PDF.

Setting 5: Sheet Options

Page Setup → Sheet tab has four checkboxes that quietly affect output quality:

• Print gridlines — off by default. Turn on if you want the grid visible. Off looks like a published report; on looks like a working spreadsheet.
• Black and white — off by default. If accidentally turned on, kills color coding and conditional formatting.
• Draft quality — off by default. If on, charts and images degrade.
• Row and column headings — off by default. Turn on only if recipients need to know which Excel row contains a value.

If your PDF looks washed out and you cannot figure out why, this tab is usually the culprit.

Worked Example: A Wide Quarterly Report

For a 24-column report with 200 rows, the sequence that almost always works:

1. Page Layout → Orientation: Landscape.
2. Page Layout → Size: A3 (or Tabloid in the US) instead of Letter, because 24 columns at readable size do not fit on Letter even landscape.
3. Page Layout → Scale to Fit: Width 1 page, Height Automatic.
4. Page Layout → Print Titles → Rows to repeat at top: $1:$2 if the header is two rows.
5. Page Layout → Print Titles → Columns to repeat at left: $A:$A if column A holds account or product labels.
6. Page Setup → Margins → Center on page: Horizontally on, Vertically off.
7. Page Setup → Sheet: verify Black and white off, Draft quality off.
8. File → Save As → PDF, Options → Entire workbook (if multiple sheets).
9. Open the resulting PDF and verify before sending.

Step 9 is the easy one to skip. Do not skip it. The fix sequence usually works, but if anything is off, the verification catches it.

When the Online Converter Helps

The Excel route is sometimes the wrong tool:

• You don't have Excel installed (working from a phone or borrowed laptop).
• The workbook contains macros that Excel mobile or web cannot run.
• You need to convert dozens of files at once.
• Your local Excel version has bugs that mangle specific layouts.

For these, the Excel to PDF converter runs server-side with a full Excel-compatible engine. Upload the .xlsx, get back a PDF that respects the same Page Setup the file already has.

Three Issues That Aren't Page Setup

Three problems are not solved by Page Setup. If you hit one, the workbook itself needs adjusting.

Numbers showing as ####. Column is too narrow for the formatted number. Auto-fit columns first (Home → Format → AutoFit Column Width). The PDF inherits the new widths.

Conditional formatting that prints as black bars. Excel's color export sometimes fails on rules that use a custom color formula. Switch to a built-in 3-color scale and the export usually works.

Hyperlinks that do not work in the PDF. The Save As PDF route preserves them; Print to PDF often does not. If you need clickable links, always use Save As PDF.

Pre-Send Check

Before any Excel-derived PDF leaves your machine, do these three things:

1. Open the PDF in a viewer (Acrobat Reader, Chrome, Edge). Scroll through every page.
2. Confirm page 2 onward shows the column headers from Print Titles.
3. Confirm the last column on each page is your real last column, not a phantom truncation.

If those three pass, the file is ready to send. If any fail, the relevant setting is in this article.