How to Convert an Excel Sheet to PDF

Converting an Excel sheet to PDF is the standard way to share a spreadsheet with someone who does not need to edit it. The tricky part is making sure the data actually fits on the page — a wide spreadsheet easily spills over into multiple pages that are hard to read. This guide shows how to set the print area, pick the right page size and orientation, and scale the content so the PDF looks right. All steps use Excel's built-in features; no extra software required.

The challenge: spreadsheets are wide, pages are not

A Word document flows top-to-bottom and fits naturally on portrait pages. A spreadsheet is a grid — it has both width (columns) and height (rows), and the width is often wider than a page. If you just hit Save As PDF without setting anything up, Excel splits the columns across multiple pages, and the recipient gets a PDF where page 2 is "the right half of the sheet" — useless for reading.

The fix is to tell Excel three things before exporting: which cells to include (print area), what paper size and orientation to use, and how to scale the content to fit. Once those are set, the PDF comes out readable.

Step-by-step: convert an Excel sheet to PDF

1. Open your workbook in Microsoft Excel and select the worksheet you want to export.
2. Set the print area. Select the range of cells you want to include (e.g., A1:K50). Go toPage Layout → Print Area → Set Print Area. Only those cells will be exported.
3. Pick page size. Page Layout → Size and choose A4 or Letter (or Tabloid / A3 for very wide sheets).
4. Pick orientation. Page Layout → Orientation. Use Landscape for wide spreadsheets — most data tables fit better sideways.
5. Scale to fit. Under Page Layout → Scale to Fit, set Width: 1 page and leaveHeight: Automatic. This squeezes all columns onto one page width while letting rows flow to as many pages as needed.
6. Save as PDF. File → Save As, change the format to PDF (*.pdf), and save. Or useFile → Export → Create PDF/XPS Document.
7. Verify. Open the PDF and check that all columns are visible on each page and that rows continue onto subsequent pages cleanly.

Page setup options explained

Print Area vs entire sheet

If you skip the print area, Excel exports the used range of the sheet — which may include stray cells far to the right that you do not want. Setting an explicit print area is the single most useful step for getting a clean PDF.

Scale to Fit vs manual scale

Scale to Fit is the right default — it shrinks the content just enough to fit the page width. The alternative isPage Layout → Scale with a manual percentage (e.g., 80%), which gives you control but requires trial and error. Start with Scale to Fit and only switch to manual if the result is too small to read.

Print Titles for multi-page sheets

If your sheet spans multiple pages, set Page Layout → Print Titles → Rows to repeat at top to $1:$1 (or wherever your header row is). This repeats the header on every page so the recipient can read page 5 without flipping back to page 1 to see the column names.

Gridlines

By default, the PDF does not include gridlines — only cell borders you explicitly set. If you want gridlines, tickPage Layout → Print → Gridlines. For a clean look, prefer setting borders on the cells you want to outline rather than printing every gridline.

Exporting multiple sheets at once

If your workbook has several sheets and you want them all in one PDF:

1. Select the sheets you want to include by Ctrl+clicking (Windows) or Cmd+clicking (Mac) the sheet tabs — they become grouped.
2. Go to File → Save As → PDF and clickOptions….
3. Under Publish what, choose Entire workbook.
4. Save. Each sheet becomes a section of the PDF.

Each sheet uses its own page setup, so set the print area and orientation on every sheet before exporting — not just the active one.

Common mistakes

• Forgetting the print area. Without it, Excel exports every used cell, including stray content far from the main table. Always set an explicit print area.
• Using portrait for a wide sheet. A 12-column spreadsheet in portrait almost never fits. Switch to landscape.
• Setting both Width and Height to 1 page. This shrinks a 200-row sheet onto a single page — the text becomes unreadable. Set Width to 1 page and leave Height automatic.
• Not repeating the header row. On a multi-page export, page 2+ has no column labels. Use Print Titles to repeat the header.
• Exporting with hidden rows or columns visible.Hidden rows and columns are not exported, which is usually what you want — but if you hid them as a quick filter, unhide before exporting to avoid surprises.