How to Convert Excel to PDF Without Cutting Off Columns

Why columns get cut off

When you print or save as PDF, Excel lays the sheet out on pages at 100% scale by default. If the used area is wider than the page, Excel prints the left part of every row first, then goes back to the top for the next strip of columns. The result reads as if the table has been sliced vertically. Things that make it worse: portrait orientation, wide default margins, a stray value far to the right that stretches the “used range”, and very wide columns holding short values.

Fix 1: Landscape orientation

Page Layout → Orientation → Landscape. On A4 this gives you about 40% more width. For many tables — six to ten columns — this alone is enough.

Fix 2: Fit all columns on one page

Page Layout → Scale to Fit: set Width to 1 page and Height to Automatic. (In the Print screen this is the “Fit All Columns on One Page” option.) Excel shrinks the sheet just enough to fit the width, and lets rows flow onto as many pages as they need. This is the single most useful setting for PDFs of tables.

Fix 3: Set a print area

Select just the table you want and choose Page Layout → Print Area → Set Print Area. This stops Excel including a forgotten note in column AF, helper calculations or an old pivot table off to the side — all common reasons the “used range” is wider than the table you see.

Fix 4: Tighten margins and columns

• Page Layout → Margins → Narrow gains roughly another centimetre on each side.
• Narrow over-wide columns: select all, then double-click a column border to auto-fit to content.
• Wrap long headings (Home → Wrap Text) instead of letting them widen the column.
• Hide columns the reader doesn’t need — helper formulas, internal IDs.

Fix 5: Repeat headings and check Page Break Preview

Page Layout → Print Titles → Rows to repeat at top puts your header row on every page, so page 4 still makes sense. Then open View → Page Break Preview: blue lines show exactly where pages will break, and you can drag them. What you see there is what the PDF will contain.

The quick alternative: a converter that fits automatically

If you’d rather not touch page setup, Excel to PDF turns each worksheet into a neat table that always fits the page width. It switches to landscape automatically when a sheet has more than six columns, reduces the text size for very wide sheets, wraps long cells and repeats the header row on every page. It accepts .xlsx, .xls, CSV and OpenDocument files, and runs in your browser.

Use Excel’s own export when the look matters — branded reports, charts, colour-coded dashboards. Use the converter for data tables, exports and CSV files, especially on a phone or a computer without Excel.

When a sheet is simply too wide

Thirty columns will never be readable on one A4 page, whatever the scaling. Better options:

• Split by purpose. A summary sheet with the key columns for the reader, plus the full data as a second PDF or the original spreadsheet attached.
• Transpose a short, wide table (Copy → Paste Special → Transpose) so fields run down the page.
• Use a larger page such as A3 if it will be viewed on screen or printed on a large-format printer.
• Send the spreadsheet as well, if the reader needs to filter or sort.

Worked example: a 14-column budget

Leila needs to send her club’s annual budget to the committee as a PDF. The sheet has a “Category” column, twelve months and a “Total” column. Saving as PDF in portrait produced four pages: January–April on pages 1–2, and the remaining months and totals on pages 3–4 with no category labels.

1. Set the print area to A1:N42, excluding her scratch calculations in column Q.
2. Switched to landscape and narrow margins.
3. Shortened month headings to Jan, Feb, Mar… and auto-fitted the columns.
4. Set Scale to Fit width to 1 page.
5. Set row 1 to repeat at the top, and checked Page Break Preview: one page wide, two pages tall.
6. Saved as PDF and added page numbers with Add page numbers in the “1 / 2” format.

The committee got a two-page PDF where every row has its label and every column its heading. For the data-only version she emails the treasurer, she uses Excel to PDF on her phone — no page setup needed.

Common mistakes

• Not checking Print Preview or Page Break Preview before saving.
• Using “Fit Sheet on One Page” for long tables.
• Leaving stray content far to the right, which widens the print range.
• Forgetting that each worksheet has its own page setup — fix every sheet you’re exporting.
• Exporting the entire workbook when only one sheet was needed (choose “Active sheet” in the export options).

Tip: save these settings with the workbook. Page setup is stored in the file, so next month’s version of the same report exports correctly first time.

Google Sheets and Numbers

The same ideas apply outside Excel. In Google Sheets, File → Download → PDF opens export settings: choose Landscape, set Scale to Fit to width, set margins to Narrow, and tick “Repeat frozen rows” after freezing your header row. In Apple Numbers, use File → Print, choose landscape and adjust “Content Scale” until the columns fit, then save as PDF from the print dialog.

Combining with other documents

If the spreadsheet is part of a larger submission — a grant application or an expense claim with receipts — merge the PDF with the other documents using Merge PDF, and compress it with Compress PDF if receipts photos make it large.