How to Combine Excel Sheets into a Single PDF

Excel spreadsheets are notoriously ugly when printed or exported to PDF. Columns get cut off, page breaks land in weird spots, and somehow a 20-row table spans 14 pages. Here's how to get it right.

The Problem with Excel-to-PDF

Excel wasn't designed for page-based output. It's a grid that extends infinitely in all directions. When you hit "Save as PDF," Excel has to figure out where to break that grid into pages — and its guesses are often terrible.

Wide spreadsheets overflow to the right. Merged cells break across pages. Headers don't repeat. Gridlines vanish or appear inconsistently. Each worksheet exports as its own section with no unified page numbers.

You need to take control of the page setup before exporting.

Step 1: Set Print Areas

For each worksheet, select the range of cells you actually want in the PDF. Don't let Excel decide — tell it explicitly.

Select your data range, then go to Page Layout > Print Area > Set Print Area. This tells Excel "only this region matters."

Do this for every sheet that should appear in the final PDF.

Step 2: Configure Page Setup

Go to Page Layout and adjust these settings per sheet:

• Orientation — use Landscape for wide tables, Portrait for tall ones
• Size — A4 or Letter, match your audience's standard
• Margins — Narrow margins give you more room; 0.5 inches usually works
• Scaling — "Fit Sheet on One Page" or "Fit All Columns on One Page" prevents column overflow

The scaling option is the most important one. "Fit All Columns on One Page" ensures no column gets cut off, though it may shrink text for very wide tables. Check that the resulting font size is still legible.

Step 3: Add Headers and Repeating Rows

Under Page Layout > Print Titles, set "Rows to repeat at top." This makes your column headers appear on every page, which is essential for multi-page tables. Without it, page two onwards has numbers with no context.

You can also add page headers and footers: Insert > Header & Footer. Include the sheet name, page number, and date for professional output.

Step 4: Preview Before Exporting

File > Print (or Ctrl+P) shows you exactly what each page will look like. Flip through every page. Check for:

• Cut-off columns or text
• Blank pages (often caused by stray data in distant cells)
• Consistent formatting across sheets
• Legible font sizes after scaling

Fix issues now, not after you've sent the PDF.

Step 5: Export to PDF

File > Save As > PDF exports the active sheet. To include all worksheets, you need to select them first: right-click any sheet tab and choose "Select All Sheets," then export.

Alternatively, print to PDF (File > Print, select your PDF printer, choose "Entire Workbook" under Settings).

Combining Workbooks from Separate Files

If your data lives in multiple Excel files, export each one to PDF separately, then merge the PDFs. MyPDF's merge tool combines multiple PDFs into a single file with unified page numbering.

You can also convert Excel files directly with MyPDF — upload the spreadsheet and download a properly formatted PDF.

Common Pitfalls

Stray data in cell ZZ9999 — if your PDF has hundreds of blank pages, there's data (or formatting) in a distant cell. Press Ctrl+End to find the last used cell, then delete everything beyond your actual data. Merged cells across page breaks — merged cells that span a page boundary cause formatting chaos. Unmerge and use "Center Across Selection" instead (Format Cells > Alignment). Charts and images — these export fine if they're anchored to cells within your print area. Floating objects outside the print area may or may not appear, depending on Excel's mood.

Related Tools

• Excel to PDF — Convert spreadsheets to clean PDFs
• Merge PDF — Combine multiple exported PDFs into one
• Compress PDF — Reduce file size of image-heavy spreadsheet PDFs