›PDF Tips ›Convert ›Convert Excel to PDF

How to Convert Excel to PDF Without Cutting Off Columns

Excel turns your spreadsheet into a PDF using its print layout, which is why wide sheets get chopped into pieces. Fix the layout first and the PDF comes out right every time.

November 21, 2026 Convert 7 min read
Back to All Posts

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.

  1. Open the Page Layout tab.
  2. In the Scale to Fit group, set Width to 1 page.
  3. 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.

  1. Select the cells you want in the PDF.
  2. 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.

  1. Go to Page Layout > Print Titles.
  2. Click in Rows to repeat at top, then click the header row in your sheet. Excel fills in a reference like $1:$1.
  3. 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.

Use Save As, not a PDF printer, if you have links. Saving as PDF from Excel usually keeps hyperlinks clickable. Printing to a virtual printer such as Microsoft Print to PDF produces a flat printout, and the links stop working.

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.

  1. Go to File > Download > PDF.
  2. Under Export, choose the current sheet, the whole workbook, or selected cells.
  3. Set Page orientation to Landscape.
  4. Set Scale to Fit to width.
  5. 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.
  6. 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

ProblemCauseFix
Blank pages at the end of the PDFFormatting or a stray value far beyond your dataPress 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 readToo many columns squeezed onto one page widthUse landscape and larger paper, hide columns nobody needs, or split the data across two printouts
No gridlines in the PDFGridlines don't print by defaultTurn on Page Layout > Sheet Options > Gridlines > Print
Chart is cut in halfThe chart crosses a page breakMove or resize it in Page Break Preview, or select the chart and export only the selection
Hyperlinks don't workThe PDF was made with a print driverUse File > Save As > PDF instead
Only one sheet exportedOptions was left on Active sheetClick 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:

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.

Key Takeaways
  • 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.

Merge PDFs Free
Free PDF tools to merge, compress and convert PDFs