How to Convert Excel to PDF Without Cutting Off Columns

To convert Excel to PDF without cutting off columns, open the Page Layout tab, set Scaling to "Fit All Columns on One Page" (or set Width to 1 page under Scale to Fit), switch to Landscape orientation, then save or print to PDF. Always check Print Preview first: if every column shows on one sheet there, the PDF will match it exactly.

Key takeaways

• Columns get sliced off because Excel's default print width is narrower than your data, so anything past the page edge spills onto a separate sheet.
• The single biggest fix is Width set to 1 page under Page Layout > Scale to Fit — it shrinks columns just enough to fit them side by side.
• Landscape orientation buys you extra horizontal room before you have to shrink anything.
• Setting a clean Print Area stops stray empty columns from pushing your real data off the page.
• Print Preview is your truth check: what you see there is exactly what the PDF will look like.
• For very wide sheets there's a real limit — past a point you'll either accept tiny text or split the data across page groups.

Why does my Excel get cut off in PDF?

Here's the honest answer most people never get told: a PDF is a fixed, paper-style page. Excel, by contrast, is an endless grid that scrolls sideways forever. When you turn a spreadsheet into a PDF, Excel has to decide where the "paper" ends — and by default it ends at the right edge of a standard Letter or A4 sheet in portrait mode.

If your data is wider than that invisible boundary, Excel doesn't shrink it for you. It simply breaks the page. Columns A through G might land on page one, and columns H onward get exiled to page two, three, or four. In the PDF, that looks like your table was sliced down the middle with scissors.

A few common culprits make it worse:

• Portrait orientation when your data is clearly landscape-shaped — wide, not tall.
• No scaling, so Excel prints every column at full size no matter how many there are.
• A bloated print area. Sometimes an old formula result or a stray space far off to the right tricks Excel into thinking your sheet is much wider than the part you actually care about.
• Hidden wide columns that are still counted in the page width even though you can't see them.

Once you understand that Excel is fitting your grid onto fixed paper, the fix becomes obvious: you tell Excel how wide that paper should behave, instead of letting it guess.

The fastest fix: fit all columns to one page wide

This is the step that solves the cut-off problem for the vast majority of spreadsheets. You're telling Excel: however many columns I have, squeeze them so they all fit across the width of a single sheet.

1. Open your workbook and click the Page Layout tab in the ribbon.
2. Find the Scale to Fit group.
3. Set Width to 1 page and leave Height set to Automatic.

That last detail matters. If you set both Width and Height to 1 page, Excel will cram a 200-row sheet onto a single tiny page and your text becomes unreadable. Setting only the Width to 1 page keeps your columns together horizontally while letting the rows flow naturally across as many pages as they need.

In newer versions of Excel and in Microsoft 365, you can do the same thing from the print dialog: choose File > Print, then under Settings open the scaling dropdown and pick Fit All Columns on One Page. It applies the same Width-to-1-page rule, just from a different menu.

Step-by-step: convert Excel to PDF the right way

Here's the full, reliable workflow from start to finish.

1. Clean up your sheet first. Delete genuinely empty columns to the right of your data, and unhide any hidden columns so you can see what's actually included.
2. Set the print area. Select only the cells you want in the PDF, then go to Page Layout > Print Area > Set Print Area. This stops Excel from including blank space that pushes columns off the page.
3. Choose Landscape orientation. Under Page Layout > Orientation, pick Landscape. Wide tables almost always look better — and lose fewer columns — this way.
4. Apply Width to 1 page. In the Scale to Fit group, set Width to 1 page and Height to Automatic, as described above.
5. Open Print Preview. Go to File > Print and study the preview pane. Scroll through every page. If all your columns appear on each sheet without being clipped, you're ready.
6. Save as PDF. Choose File > Save As, pick PDF from the file-type dropdown, and save. Or in the print dialog, select Microsoft Print to PDF (or Save as PDF on a Mac) as the printer.

That's it. Because you confirmed the layout in Print Preview, the resulting PDF will match what you saw — no surprises.

If you're working from a browser or a device without the full Excel app, you can also upload the spreadsheet to an online converter and adjust the same width and orientation settings there, then download the finished PDF.

The realistic failure mode (and how to handle it)

Here's where people get frustrated, so let's be straight about it. Fitting all columns to one page works by shrinking them — and there's a floor. If you have 40 columns of data, fitting them all across one sheet will make the text so small it's barely legible. Excel will technically obey you, but nobody will be able to read the result.

When you hit that wall, you have three honest options:

• Accept smaller text if the PDF is just for reference or archiving, where readability per cell matters less than seeing the whole picture at a glance.
• Split the data across page groups. Print columns A–M as one logical block and N–Z as another. You can do this by adjusting the print area in two passes, or by inserting manual page breaks (Page Layout > Breaks > Insert Page Break).
• Rethink whether it should be a PDF at all. If the recipient needs to sort, filter, or do math on the numbers, a flattened PDF fights against them. We dig into exactly when that trade-off makes sense in PDF vs Excel: when a spreadsheet should and shouldn't be a PDF.

Knowing the limit ahead of time saves you from squinting at a wall of microscopic numbers and wondering what went wrong.

Extra controls that help wide spreadsheets

A few lesser-known settings make a real difference on stubborn sheets.

Repeat headers on every page

If your rows spill across several pages, the column titles only appear on page one by default — which makes pages two and beyond confusing to read. Fix it with Page Layout > Print Titles > Rows to repeat at top, and select your header row. Now every PDF page carries the labels, so a reader on page four still knows which column is which.

Adjust the margins

Shrinking your margins gives columns more breathing room before scaling kicks in. Under Page Layout > Margins, choose Narrow. Sometimes that small change is enough to fit one more column without shrinking everything else.

Center the content

If your table is narrower than the page but sitting awkwardly to one side, open Page Setup (the small arrow in the corner of the Page Setup group), go to the Margins tab, and tick Horizontally under "Center on page." It won't fix cut-off columns, but it makes the final PDF look polished and intentional.

Use Page Break Preview

Switch to View > Page Break Preview to see exactly where Excel intends to slice your sheet. The blue lines show page boundaries, and you can drag them to control which columns stay together. It's the most visual way to catch a cut-off before it ever reaches the PDF — far easier than guessing from the normal grid view.

What about the reverse direction?

Sometimes you receive a PDF and need the spreadsheet back — extracting tables from a PDF into editable Excel rows and columns. That's a different challenge with its own pitfalls around merged cells and column alignment, and we cover it in how to convert PDF to Excel and keep tables intact. If you only need to tidy up an existing PDF rather than convert it, you can open it directly in our online PDF editor and adjust pages, text, and layout there.

FAQ

Why does my Excel get cut off in PDF?

Excel prints onto fixed-size pages, but your spreadsheet grid is wider than a standard sheet. When your columns exceed that width, Excel pushes the overflow onto separate pages instead of shrinking everything to fit. The cure is to set Scaling to "Fit All Columns on One Page" and switch to Landscape so the full width lands on one sheet.

How do I convert Excel to PDF fit to page?

Go to the Page Layout tab, find Scale to Fit, and set Width to 1 page with Height left on Automatic. This fits all your columns across a single page while letting the rows flow naturally down as many pages as they need. Then save as PDF or print to PDF, and confirm the result in Print Preview first.

Should I use Portrait or Landscape for an Excel to PDF conversion?

Use Landscape for most spreadsheets, since they tend to be wider than they are tall. Landscape gives you more horizontal room, which means Excel has to shrink your columns less — or not at all — to fit them. Switch to Portrait only when your data has few columns and many rows.

Does converting xlsx to PDF change my formulas or data?

No. A PDF is a flat snapshot of how your sheet looks when printed, so it captures the displayed values, not the live formulas behind them. The numbers shown stay exactly as they appear in Excel. Just remember that the recipient can read the PDF but can't recalculate or edit the cells.

Why are some columns blank or missing in my PDF?

Usually it's the print area. If you accidentally set or inherited a print area that doesn't include all your columns, Excel only exports that region. Go to Page Layout > Print Area > Clear Print Area, reselect the full range you want, and set it again. Hidden columns are the other common cause — unhide them before converting.

Can I convert Excel to PDF without installing software?

Yes. You can upload your xlsx file to an online converter, set the width and orientation options in the tool, and download the finished PDF. Files are processed on the server and not kept long-term, so it's a practical option when you're away from the full desktop Excel app.