Excel to PDF Settings: Print Area, Scaling, Headers

One of the most frustrating issues when converting Excel spreadsheets to PDF is finding that content has been cut off — columns disappear at the right edge, or rows spill onto unexpected extra pages. This guide walks you through every important setting for a clean, professional PDF export from Excel, including print area setup, scaling options, page orientation, multi-sheet handling, and the differences in Mac Excel.

Basic Conversion Steps

1. Open your Excel file.
2. Click File → Export → Create PDF/XPS Document, then click Create PDF/XPS.
3. Alternatively, use File → Save As and select PDF (*.pdf) from the file type dropdown.
4. Click Options to access advanced settings (strongly recommended).
5. Click Publish or Save to complete the export.

Setting the Print Area: Export Only What You Need

If your spreadsheet contains empty rows, helper columns, or data you do not want to include in the PDF, setting a defined print area is the most effective way to control what gets exported:

1. Select the cell range you want to export.
2. Go to the Page Layout tab in the ribbon.
3. Click Print Area → Set Print Area.
4. Excel will remember this range for all future PDF exports from this file.
5. To clear the print area, click Print Area → Clear Print Area.

Scaling Options: Fitting All Columns Into the PDF

Scaling is the most important tool for preventing content from being cut off. There are two ways to set scaling in Excel:

Option 1: Page Layout tab settings

• In the Page Layout tab, find the Scale to Fit section.
• Set Width to 1 page and Height to Automatic to fit all columns on one page width without restricting the number of rows.
• Set both Width and Height to 1 page to fit everything on a single page (suitable for smaller spreadsheets only).

Option 2: Print preview settings

1. Press Ctrl + P (or Command + P) to open the print preview.
2. Click the No Scaling dropdown and select one of the following:
   • No Scaling: Exports at the original scale.
   • Fit Sheet on One Page: Forces all content onto a single page.
   • Fit All Columns on One Page: The most commonly used option — ensures no columns are cut off.
   • Fit All Rows on One Page: Ensures no rows are cut off.
   • Custom Scaling Options: Set a specific percentage manually.

Choosing Between Portrait and Landscape Orientation

When your spreadsheet has many columns, landscape orientation allows more content to fit on each page:

• Go to Page Layout → Orientation → Landscape.
• You can also switch orientation in the print preview.
• Landscape orientation combined with “Fit All Columns on One Page” scaling solves the vast majority of column truncation issues.

Use portrait orientation for spreadsheets with many rows but few columns.

Handling Multiple Sheets

By default, Excel only exports the currently active sheet. To combine multiple sheets into a single PDF file, use one of these approaches:

• Select multiple sheets manually: Hold Ctrl and click each sheet tab at the bottom of the workbook to select multiple sheets, then export.
• Select all sheets: Right-click any sheet tab and choose Select All Sheets, then export.
• In the export Options dialog, choose Entire Workbook to include all sheets in the PDF.

Keep in mind that page layout settings (orientation, scaling) are configured individually for each sheet. To get consistent output across all sheets, you need to apply your settings to each sheet separately before exporting.

Repeating Header Rows on Every Page

For multi-page PDFs, having the header row repeat at the top of each page significantly improves readability:

1. Go to Page Layout → Print Titles.
2. In the Rows to repeat at top field, select the row containing your headers (for example, Row 1).
3. Click OK. The selected header row will appear at the top of every page in the exported PDF.

Excel for Mac: Key Differences

PDF export in Excel for Mac works similarly to Windows, but with a few differences:

• Use File → Save As, then select PDF from the Format dropdown, and click Export.
• Alternatively, press Command + P, click PDF in the bottom left, then select Save as PDF.
• Page Layout and scaling settings in Mac Excel are found in the same Page Layout tab as in Windows.
• Use Excel’s built-in export rather than the macOS print-to-PDF method for better layout control and consistent output.

Troubleshooting Common Problems

• Right-side columns are cut off: Apply “Fit All Columns on One Page” scaling, or switch to landscape orientation.
• Unwanted blank pages in the PDF: Set a print area to exclude empty rows and columns, and check for accidental manual page breaks in Page Layout view.
• Gridlines not showing: In Page Layout → Sheet Options, check the Print checkbox under Gridlines.
• Font display issues: Verify that fonts used in the spreadsheet support embedding, and preview the output before finalizing.
• Charts appearing outside the page boundary: Resize charts to fit within the defined print area before exporting.

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