Excel to PDF Cutting Off Columns? How to Fix It

By PDFwarp · · 4 min read

Excel columns running onto extra PDF pages? Set the sheet to fit one page wide, switch to landscape, then convert. Steps for Excel and PDFwarp.

Convert Word to PDF now →

Excel turns a sheet into a PDF the way it would print it. If the sheet is wider than one page, the right-hand columns spill onto extra pages. The fix is in the workbook, before you convert: on the Page Layout tab set Width to 1 page and Height to Automatic, switch to Landscape, and save. PDFwarp's Office to PDF follows the page setup saved in the file.

Why the columns get cut off

A PDF is made of pages, and a spreadsheet has no page edge. Excel decides where one page ends and the next begins from the paper size, the margins and the scale. If your columns add up to more than the width of the paper, everything past that line moves to a new page. You see the first columns on page 1 and the rest on page 3 or 4, and a table that was easy to read on screen is now in pieces.

Converting to PDF does not cause this. A converter only copies what the print setup already says. So the cure is the same whether you save as PDF in Excel or use an online tool.

Fix it in Excel

These steps are for Excel on a computer.

1. Open the Page Layout tab.

2. In the Scale to Fit group, set Width to 1 page and leave Height on Automatic. Every column now fits across one page, and the rows carry on to as many pages as they need.

3. Under Orientation, choose Landscape. A landscape page is wider, so the text stays larger.

4. Under Margins, choose Narrow if you still need room.

5. Press Ctrl+P (File, then Print) and look at the preview on the right. It shows the pages the PDF will have.

6. Save the workbook.

If you only want to check the result, the same screen has a scaling menu with Fit All Columns on One Page.

See where the pages break

On the View tab, choose Page Break Preview. Dashed blue lines show where Excel splits the sheet. You can drag a line to move the break. Go back with Normal view. This is the quickest way to find the one column that is pushing everything over.

Then convert it with PDFwarp

1. Open Office to PDF and upload the saved .xlsx or .xls file. It converts one file at a time.

2. Click Office → PDF, then download the PDF.

3. Open the PDF and flick through the pages before you send it.

PDFwarp converts the file on its servers with LibreOffice and deletes it as soon as the result is sent back. We tested a workbook with one wide sheet and one sheet set to fit one page wide: the first ran across four portrait pages, and the second came out as a single landscape page. So the setting you save in Excel is the setting you get. If LibreOffice cannot open a file, a simpler backup converter takes over: it lays out each sheet's saved values as a plain table and ignores the page setup.

Two things to know. Every sheet in the workbook is converted, in tab order. If you only want one sheet, right-click its tab, choose Move or Copy, pick "(new book)", tick Create a copy, and convert that new file. And any file you convert must fit the limits: guests get 2 conversions a day with uploads up to 10 MB, and a free account gets 5 a day and 25 MB.

When the text gets too small

Fitting 25 columns onto one page makes each column narrow, and the type shrinks with it. If you have to squint, try these instead:

What can still go wrong

PDFwarp's server has no copy of every font on your computer, so an unusual font is replaced with a close one. The letters can be a little wider or narrower than in Excel, and a column that just fit can tip over. Leave a little spare room at the right edge. The tool page also warns that columns, text boxes and custom fonts can shift. If you have Excel, its own File, Save As, PDF gives you exactly what Excel prints, so use that when the layout has to be perfect.

Password-protected workbooks are not accepted. Remove the password in Excel first.

After you have the PDF

If it is too big to email, see how to compress a PDF to under 1 MB. If it is one of several documents going in the same file, Merge PDF puts them in the order shown on screen. For the Word and PowerPoint versions of this problem, see how to convert Word to PDF. For PowerPoint slides with speaker notes or several slides per page, see PowerPoint to PDF with notes or handouts.

FAQ

Why does Excel print half my columns on another page?

The sheet is wider than the paper at the current scale. Set Width to 1 page on the Page Layout tab, or switch to landscape.

Will an online converter fix a cut-off sheet?

Not by itself. It prints what the file's page setup says. Fix the setup in Excel first, then convert.

Does PDFwarp convert every sheet?

Yes. Every sheet in the workbook is converted, in the order of the tabs.

Can I convert Excel to PDF without Excel?

Yes, with Office to PDF online, but you cannot fix the page setup without a spreadsheet program. Free options such as LibreOffice Calc have a similar Format, Page Style, Sheet setting.

Convert Word to PDF now →