How to Convert Excel to PDF Without Cutting Off Columns

Sep 5, 2026 · Idea2Grow · 1 min read

To convert Excel to PDF: use File → Save As → PDF in Excel, or upload the file to an Excel to PDF converter. The tricky part isn't the conversion — it's making sure the whole spreadsheet fits on the page. Here's how.

Fix the layout before you convert

Almost every "my Excel PDF looks wrong" problem is the sheet being wider than the paper, so columns fall off the right edge onto their own pages. Set these four things first:

Print area: select the cells you actually want, then Page Layout → Print Area → Set Print Area. This stops empty columns from padding the width.
Orientation: switch to Landscape for wide tables (Page Layout → Orientation).
Scaling: set "Fit All Columns on One Page" (Page Layout → Scale to Fit → Width: 1 page). Height can stay automatic so long tables flow across multiple pages.
Page breaks: use View → Page Break Preview to see exactly where each page ends and drag the break lines if needed.

Then convert

With the layout set, export: File → Save As, choose PDF, and pick "Selection" or "Active Sheet" if you don't want every tab in the workbook turned into pages. If you don't have Excel on the machine, the online converter applies sensible fit-to-width defaults automatically.

Two details people miss

Gridlines: they don't appear in the PDF unless you enable them (Page Layout → Sheet Options → Gridlines → Print) or use real borders.
Headers on every page: set "Rows to repeat at top" (Page Layout → Print Titles) so a long table keeps its column headers on each page of the PDF.

The reverse

Pulling a table out of a PDF and back into a spreadsheet is covered in how to convert a PDF to Excel.

Frequently asked questions

How do I convert an Excel file to PDF?

Either use Excel's built-in File → Save As → PDF (or File → Export → Create PDF), or upload the .xlsx to an Excel-to-PDF converter. Both produce a PDF; the converter is handy when you don't have Excel installed.

Why do my columns get cut off in the PDF?

The sheet is wider than the page. Before converting, set the print area to just the cells you need, switch to landscape orientation, and use 'Fit All Columns on One Page' scaling. That forces the whole width onto each page instead of letting it overflow.

How do I convert only one sheet instead of the whole workbook?

Select just that sheet's tab before exporting, and choose 'Selection' or 'Active Sheet' rather than 'Entire Workbook' in the export options. Otherwise every tab in the file becomes pages in the PDF.

How do I keep gridlines visible in the PDF?

Gridlines don't print by default. In Excel, go to Page Layout → Sheet Options and tick 'Print' under Gridlines before converting, or add real cell borders to the range.