You save a spreadsheet as a PDF, open the result, and the last three columns are sitting alone on page 2. Or page 4. Or scattered across a dozen pages that make no sense on their own. This happens because Excel builds the PDF from its print layout, and that layout is set by paper size, margins, and scaling, not by what you see on screen. The fix is to adjust the print layout before you convert Excel to PDF. It takes a couple of minutes, and once a sheet is set up, every export after that comes out right.
Why Excel Cuts Off Columns in a PDF
On screen, a worksheet is one endless grid. On paper, it has to be chopped into pages. Excel divides the grid into page-sized blocks, working down first and then across. If your sheet is wider than one page, the columns that don't fit get printed after all the rows are done, which is why they show up far from the data they belong to.
Saving as PDF, exporting to PDF, and printing to a PDF printer all use those same page breaks. So the job is really about getting the print layout right. The steps below are for Excel on Windows and Mac. Google Sheets and LibreOffice are covered further down.
Step 1: See Where the Page Breaks Fall
Go to View > Page Break Preview. Excel greys out everything outside the printable area and draws blue lines where each page ends. Dashed lines are automatic breaks and solid lines are ones you've set by hand. If you see a dashed line running down through your columns, that's where the PDF will split.
You can drag the blue lines to change where pages break. Dragging a vertical break line to the right edge of your data tells Excel to fit those columns on one page, and it shrinks the scale to make that happen. Switch back with View > Normal when you're done.
Step 2: Fit All Columns on One Page Wide
This is the setting that fixes most cut-off columns.
- Open the Page Layout tab.
- In the Scale to Fit group, set Width to 1 page.
- Leave Height on Automatic so long sheets can still run across several pages.
You can do the same thing from File > Print. The last setting under Settings is a scaling dropdown, and one of its choices is Fit All Columns on One Page.
Avoid Fit Sheet on One Page for anything longer than a screen or two. It squeezes rows and columns together until the whole sheet fits on a single page, and on a large sheet the text becomes unreadable.
Step 3: Switch to Landscape and Narrow the Margins
Fitting more columns per page means less shrinking, and less shrinking means bigger text in the PDF.
- Page Layout > Orientation > Landscape gives you about 30 to 40 percent more width, depending on paper size.
- Page Layout > Margins > Narrow recovers another half inch or so on each side.
- Page Layout > Size lets you pick larger paper. If the PDF will only be read on screen, choosing Legal, Tabloid, or A3 gives very wide sheets plenty of room. People can zoom in a PDF viewer, so paper size matters less than it seems.
Step 4: Set a Print Area
Many workbooks have scratch columns, helper formulas, or notes off to the side that nobody needs in the PDF. A print area tells Excel to ignore everything else.
- Select the cells you want in the PDF.
- Go to Page Layout > Print Area > Set Print Area.
Excel remembers the print area when you save the workbook. To remove it later, use Print Area > Clear Print Area.
Step 5: Repeat the Header Row on Every Page
A 400-row table that runs onto ten pages is hard to read if only page 1 shows the column headings. Excel can repeat them automatically.
- Go to Page Layout > Print Titles.
- Click in Rows to repeat at top, then click the header row in your sheet. Excel fills in a reference like $1:$1.
- Click OK.
The same dialog has Columns to repeat at left, which is useful when the first column holds names or IDs and your data runs across more than one page wide.
Step 6: Save the Spreadsheet as a PDF
Excel for Windows: go to File > Save As, pick a location, and change Save as type to PDF. Before you click Save, click Options. This is where you choose what goes into the PDF:
- Active sheet(s) exports the current sheet, or every sheet you've selected.
- Entire workbook exports every sheet, each with its own page setup.
- Selection exports only the highlighted cells.
- Ignore print areas exports everything, even if you set a print area.
You'll also see Optimize for: Standard is best for printing, and Minimum size makes a smaller file for email or upload. File > Export > Create PDF/XPS opens the same options.
Excel for Mac: go to File > Save As and choose PDF from the File Format list. You can also use File > Print and choose Save as PDF from the PDF menu in the lower-left corner.
Exporting a Whole Workbook in One Go
Every sheet in a workbook has its own page setup, so a workbook export can look fine on Sheet1 and fall apart on Sheet3. You don't have to fix each sheet one at a time. Hold Ctrl (or Cmd on a Mac) and click each sheet tab to group them. Page Layout changes now apply to every grouped sheet at once. Set landscape, width to 1 page, and narrow margins, then right-click a tab and choose Ungroup Sheets before you edit any cells. While sheets are grouped, typing in one cell types into the same cell on every grouped sheet.
If you'd rather keep each sheet as its own PDF, export them separately and combine them later with our Merge PDF tool. Our step-by-step on how to merge PDF files for free shows how to put them in the right order.
Converting from Google Sheets
Google Sheets has its own export panel with the settings you need.
- Go to File > Download > PDF.
- Under Export, choose the current sheet, the whole workbook, or selected cells.
- Set Page orientation to Landscape.
- Set Scale to Fit to width.
- Turn on gridlines if you want them, and switch on the option to repeat frozen rows so headers appear on every page. Google moves these between the Formatting and Headers & footers sections from time to time.
- Click Export.
To repeat a header row in the PDF, freeze it first with View > Freeze > 1 row.
Converting from LibreOffice Calc
In LibreOffice, scaling lives in the page style. Go to Format > Page Style, open the Sheet tab, and set Scaling mode to Fit print range(s) to width/height. Enter 1 for width and leave height large. Then use File > Export as PDF. The export dialog has a long list of options, but the defaults are fine for most spreadsheets.
Common Problems and Fixes
| Problem | Cause | Fix |
|---|---|---|
| Blank pages at the end of the PDF | Formatting or a stray value far beyond your data | Press Ctrl+End to find Excel's idea of the last cell, then delete unused rows and columns, or set a print area |
| Text is too small to read | Too many columns squeezed onto one page width | Use landscape and larger paper, hide columns nobody needs, or split the data across two printouts |
| No gridlines in the PDF | Gridlines don't print by default | Turn on Page Layout > Sheet Options > Gridlines > Print |
| Chart is cut in half | The chart crosses a page break | Move or resize it in Page Break Preview, or select the chart and export only the selection |
| Hyperlinks don't work | The PDF was made with a print driver | Use File > Save As > PDF instead |
| Only one sheet exported | Options was left on Active sheet | Click Options in the Save As dialog and choose Entire workbook |
After You Convert: Useful Next Steps
Once the spreadsheet is a PDF, a few free tools can finish the job:
- Lock it down. Financial reports often need a password. Our guide on how to password protect a PDF explains open passwords versus permission restrictions.
- Shrink it. Sheets with embedded images or charts can produce large files. The Compress PDF tool brings them down for email.
- Print part of it. If you only need a few pages of a long export on paper, here's how to print specific pages of a PDF.
- Go the other way. Got a PDF table you need back in a spreadsheet? See how to convert PDF to Excel for free.
The same idea of getting the layout right first applies to documents too. If you're also sending Word files, our guide to converting Word to PDF and keeping your formatting covers the details.
- Excel builds a PDF from its print layout, so fix page breaks and scaling before you convert Excel to PDF
- Set Page Layout > Scale to Fit > Width to 1 page and leave Height on Automatic to keep every column on the page
- Landscape orientation, narrow margins, and larger paper sizes reduce shrinking and keep text readable
- Use a print area to drop helper columns, and Print Titles to repeat headers on every page
- Use File > Save As > PDF and the Options button to export one sheet, a selection, or the whole workbook with links intact
- In Google Sheets, export with Fit to width; in LibreOffice, use the Fit print range(s) scaling mode
Combining several exported sheets?
Merge multiple PDFs into one file, then compress or protect it. All free, all in your browser.