Export Excel as PDF: A Step-by-Step Walkthrough

Exporting an Excel spreadsheet to PDF is straightforward, but getting the output to look right takes a few extra steps. Columns getting cut off, blank pages appearing, or oversized tables spilling across multiple pages are all common issues. This guide walks through print area setup, scaling, orientation, multi-sheet export, and headers and footers — so your PDF comes out clean every time.

1. Basic PDF Export

1. Open your workbook and navigate to the sheet you want to export.
2. Click File → Save As or Export.
3. Select PDF (*.pdf) as the file type.
4. Click Options to configure page range and quality before saving.
5. Click Save or Publish to create the PDF.

Alternatively, use Print Preview: click File → Print, select Microsoft Print to PDF (Windows) or Save as PDF (Mac) from the printer dropdown, and review the layout before exporting.

2. Set a Print Area to Avoid Blank Pages

If your sheet has data interspersed with empty rows or columns, Excel may include unwanted blank pages in the PDF:

1. Select only the cells you want to export (e.g., A1:H50).
2. Click the Page Layout tab → Print Area → Set Print Area.
3. Excel will only include this defined area in the PDF output.
4. To clear it: Page Layout → Print Area → Clear Print Area.

3. Scale to Fit One Page Wide (Prevent Content Cut-Off)

If your table is wider than one page, use scaling to fit all columns:

1. Click Page Layout and find the Scale to Fit group.
2. Set Width to 1 page and leave Height set to Automatic so rows extend naturally across multiple pages.
3. To compress everything onto a single page, set both Width and Height to 1 page — but be aware this can make text very small.
4. In Print Preview, you can also choose Fit Sheet on One Page from the scaling dropdown.

4. Choose Page Orientation

• Wide tables with many columns: use Landscape orientation via Page Layout → Orientation → Landscape.
• Tall tables with many rows but few columns: Portrait orientation works better.
• Check the result in Print Preview before exporting.

5. Adjust Page Margins

1. Click Page Layout → Margins and choose from Normal, Wide, or Narrow presets.
2. Choose Custom Margins to enter precise values for top, bottom, left, and right.
3. Narrower margins allow more content per page, but avoid going too narrow or content may be clipped by printers.

6. Export Multiple Sheets to a Single PDF

1. Hold Ctrl and click each sheet tab you want to include, or hold Shift to select a range of tabs.
2. The title bar will show “[Group]” to confirm the selection.
3. Go to File → Save As → PDF. All selected sheets will be combined into one PDF file, each sheet as a separate section.
4. After exporting, click any unselected tab to deselect the group.

7. Add Headers and Footers

1. Click Insert → Text group → Header & Footer to enter editing mode.
2. Insert automatic elements: page number, sheet name, file name, date, time, or an image (such as a company logo).
3. Alternatively, click the small dialog launcher in the Page Setup group (Page Layout tab) and switch to the Header/Footer tab.
4. These settings will appear in your PDF output as well.

8. Troubleshooting Common Issues

• Extra blank pages in the PDF: Clear and reset the print area, then verify in Print Preview.
• Columns cut off on the right: Switch to Landscape orientation or set Width scaling to 1 page.
• Charts not included in PDF: Make sure the chart is inside the defined print area, or select the chart separately and export it individually.
• Blurry text in the PDF: Use Standard quality instead of Minimum size in the export options.

With the right print area, scaling, and orientation settings, your Excel-to-PDF exports will look polished and professional every time. For further PDF tasks — merging, compressing, or splitting files — use the free tool below.

Do it in your browser — the file never leaves your device: PDF Tools