How to convert Excel to PDF without cutting off columns

Why does my Excel PDF split across pages?

A spreadsheet has no page. It is a grid that keeps going in both directions, and a PDF is a stack of fixed pages. When you export, Excel lays Letter-size pages over the grid at 100 percent scale and cuts wherever a page edge falls. A table that is nine columns wide fits eight on page one and sends column I to page two, which then becomes its own near-empty page in the PDF. Tall sheets do the same downward, which is expected; wide sheets doing it sideways is what most people are trying to stop.

Two other things inflate a PDF. The print area may include cells far away from the data, often a stray space typed in cell AZ400 months ago, so Excel exports dozens of blank pages. And Excel exports every sheet if you choose Entire workbook, including hidden helper sheets you forgot about. The fix is to tell Excel how the grid should map onto pages before you export, using scaling, a print area and the orientation, all on the Page Layout tab.

Fit an Excel sheet to one page before exporting

The setting that keeps columns together is Scale to Fit. Set Width to 1 page and leave Height on Automatic. Excel shrinks the sheet just enough for all columns to fit across one page and lets the rows flow onto as many pages as they need. This is what people mean by one page wide, and it is the right choice for nearly every table.

If you want the whole sheet on a single page, set Height to 1 page as well, then check the Scale box: below about 60 percent the text becomes hard to read on paper. When a sheet needs that much shrinking, split it into two print areas or switch to landscape instead.

If you prefer the dialog, click the small arrow in the corner of the Page Setup group, choose Fit to, and enter 1 page wide by 1 tall, or leave the tall box blank for automatic. If you would rather skip page settings altogether, Excel to PDF online lays out each sheet as one section of the PDF for you.

1. Open the sheet and click the Page Layout tab.
2. In the Scale to Fit group, set Width to 1 page.
3. Leave Height on Automatic for a table that may run several pages, or set it to 1 page for a single-page export.
4. Check View, Page Break Preview. Blue lines show where pages end; drag a line to move a break.

Set a print area, landscape and repeating headers

A print area tells Excel which cells to export and ignores everything else. Select the range you want in the PDF, then click Page Layout, Print Area, Set Print Area. To check what Excel currently thinks the used range is, press Ctrl+End; if it lands far from your data, delete those rows and columns or set a print area.

Wide tables with few rows belong in landscape. Click Page Layout, Orientation, Landscape. Combined with Narrow margins (Page Layout, Margins, Narrow) this often fits a 12-column table at a readable scale without any shrinking.

For a table that runs several pages, repeat the header row on each page: Page Layout, Print Titles, then click in Rows to repeat at top and select row 1. Each PDF page then starts with the column names instead of a bare row of numbers. Under Page Setup, Margins, tick Horizontally under Center on page so a narrow table does not sit in the left corner.

Save Excel as PDF on Windows and Mac

On Windows, click File, Save As, pick a folder, and choose PDF in the Save as type list. Before saving, click Options to choose what goes in: Active sheet(s), Entire workbook, Selection, or a page range. If you only want what you would print, Ctrl+P, choose Microsoft Print to PDF as the printer and click Print; this respects the same page settings and is useful when the Save As PDF option is missing.

On a Mac, click File, Save As, choose PDF from the File Format menu, and pick Sheet or Workbook. Or press Cmd+P, click the PDF button at the bottom left of the print dialog and choose Save as PDF, which also lets you set a password in Security Options. Both routes use the Page Layout settings you set in the previous sections, so get those right first and the PDF will look like Print Preview.

Excel for the web exports with File, Save As, Download as PDF, and Excel on iPhone or Android has a Share or Export option that produces a PDF with the same scaling rules.

1. Windows: File, Save As, choose PDF, click Options, pick Active sheet(s) or Entire workbook, then Save.
2. Windows alternative: Ctrl+P, printer Microsoft Print to PDF, Print.
3. Mac: File, Save As, File Format PDF, choose Sheet or Workbook, Save.
4. Mac alternative: Cmd+P, PDF button, Save as PDF.

Convert Excel to PDF online

When you are on a phone, on a computer without Excel, or have a folder of workbooks to convert, an online converter is quicker than opening each one. Excel to PDF converts XLSX spreadsheets to PDF tables, one section per sheet, so a workbook with Summary, Q1 and Q2 sheets produces a PDF with those three sections in order. It is free, needs no sign-up, adds no watermark, and takes files up to 300 MB and up to 50 files per batch. Files are processed in memory and deleted after 30 minutes.

Because the converter lays the table out itself, you do not need to set print areas or scaling beforehand. Check the result once, since very wide sheets are still wide and may need you to hide unneeded columns in Excel before converting. If you have a CSV rather than an XLSX, CSV to PDF turns the raw export into a printable table directly.

1. Open Excel to PDF and add one or more XLSX files.
2. Run the conversion and download the PDFs.
3. Open a PDF and check the column widths and that every sheet you expected is there.

Download a Google Sheets file as PDF

Google Sheets exports to PDF with more layout options than Excel in a single panel. Click File, Download, PDF (.pdf). On the right, choose Export: Current sheet, Workbook or Selection. Set Paper size to Letter, pick Portrait or Landscape, and under Scale choose Fit to width, which is the equivalent of one page wide. Fit to page squeezes everything onto a single page. Set Margins to Narrow for wide tables.

Open the Formatting section to show or hide gridlines and notes, and Headers and footers to add page numbers, the sheet name or the date. Under Rows and columns, tick Repeat frozen rows so your frozen header row appears on every page. Click Export and the PDF downloads.

Gridlines, row numbers and headers in the PDF

By default Excel exports without gridlines, which makes a plain table of numbers hard to follow. To print them, tick Page Layout, Sheet Options, Gridlines, Print. The lines appear only around cells that contain something, so an empty region stays blank. If you want a specific look, add borders to the table instead (Home, Borders, All Borders), which are exported whether or not gridlines are on.

The Headings checkbox next to it prints the row numbers and column letters, which is useful when the PDF goes to someone who will reply with cell references and useless otherwise. Page headers and footers are set under Page Setup, Header/Footer: the file name, sheet name, page X of Y and the date are all one click. A footer with the page number saves confusion when a long PDF is printed and reshuffled.

Protect, compress or combine the PDF afterwards

A PDF of a spreadsheet often contains salary data, prices or customer lists, and it travels further than the workbook did. If it should only be read by the recipient, run it through Protect PDF, which locks it with a password using AES-256 encryption. Send the password separately from the file.

Spreadsheets with embedded charts or logos can export to a surprisingly large PDF. Compress PDF makes it smaller for email and upload while keeping it readable. If you exported several sheets or workbooks as separate PDFs, Merge PDF combines them into one in the order you choose.

Finally, open the PDF before you send it. Check that the last column is present, that the header row repeats, that no blank pages slipped in, and that hidden sheets stayed hidden.