Skip to content

How to stop Excel cutting off columns when you save to PDF

A spreadsheet that looks fine on screen often comes out of Excel as a PDF with columns missing, split across pages, or squeezed until it can’t be read. Here is why, and how to get a PDF that shows every column, readably.

Updated 29 October 2026.

On this page

Why columns go missing

Excel prints a sheet as pages of paper. When the sheet is wider than the page, the columns that don’t fit are printed on later pages, so the first pages of the PDF show only the left-hand columns. Other things go missing too:

  • #### appears where a column is too narrow to show its number or date.
  • Text is cut off at the edge of a cell when the cell beside it isn’t empty.
  • Hidden rows and columns don’t print, and nor does anything outside a print area set in the workbook.
  • Fitting the whole sheet to one page can shrink the text until no one can read it.

For a ledger, a schedule or a trust account going into evidence, each of these matters: a reader can’t tell what is missing.

1. Work on a copy

Changing column widths, wrapping and page settings changes the workbook. If the spreadsheet is evidence, or was received from someone else, make a copy and change only the copy, so the original stays exactly as it was.

2. See where the pages break

Open Page Break Preview from the View tab, or with the button on the status bar. It shows the area that will print and where each page ends, and you can drag a page break to move it. Look for hidden columns too, shown by a jump in the column letters, and decide whether they belong in the PDF.

3. Widen columns showing ####

Microsoft’s help on correcting a ##### error says it usually means the column isn’t wide enough for its contents. Drag the right edge of the column heading to widen it, or double-click the edge to fit the column to its contents. For long text, turn on Wrap Text and let the row grow taller, rather than widening the column without end.

4. Turn the page and fit it to the width

  1. On the Page Layout tab, under Orientation, choose Landscape.
  2. In the Scale to Fit group, set Width to 1 page and Height to Automatic, as Microsoft’s help on scaling a worksheet describes. Every column then fits across one page, and the rows run on to as many pages as they need.
  3. Check the Scale figure in the same group. The lower it is, the smaller the text.

If the text ends up too small to read, don’t force it onto one page. Use bigger paper, such as A3, if your court accepts it, or let the sheet run across two pages side by side, with the headings repeated so each page still makes sense. Excel ignores manual page breaks when Fit to is used, so choose one approach or the other.

5. Repeat the headings

On the Page Layout tab, select Print Titles. On the Sheet tab, set Rows to repeat at top, such as $1:$1 for the first row, as Microsoft’s help on printing column headers on every page explains. If the sheet runs across more than one page, set Columns to repeat at left as well, so every page shows which row it is.

6. Save as PDF and check it

Choose File, then Save As, and PDF as the type. Use Options to choose what goes in, such as the active sheet only or the entire workbook. Then open the PDF and check:

  • the last column is there on every page, and the right-hand columns weren’t pushed onto later pages;
  • no cell shows ####, and no text is cut off at a cell edge;
  • the text is big enough to read on screen and on paper;
  • every sheet that should be there is there, and none that shouldn’t;
  • the headings repeat on every page.

A workbook with several sheets may need each one set up separately, since page settings belong to each sheet.

With Sudex

Sudex’s Sheets screen with four workbooks: a wide sheet of payment claims printed at 94% over two pages side by side, with the smallest text size set to 80% of normal
Sheets keeps a wide sheet readable: here it is spread over two pages side by side at 94%, rather than shrunk.
Sudex Sheets, 1:04: the real program on an invented matter.

Questions

Why does Excel show #### instead of numbers?

Usually because the column isn’t wide enough to show the whole value. Widen it by dragging the right edge of the column heading, or double-click the edge to fit it. The PDF prints whatever the cell shows, so fix these before converting.

How do I fit all the columns on one page in Excel?

On the Page Layout tab, under Scale to Fit, set Width to 1 page and Height to Automatic. The columns then fit across one page while the rows run on to more pages. Check the Scale figure: a low number means the text has been shrunk a lot.

Why are some columns missing from my Excel PDF?

They may be on later pages, because Excel prints a wide sheet in several pages across. They may also be hidden columns, which don’t print, or outside the print area. Page Break Preview shows what will print and where the pages break.

Your next bundle, built and checked in minutes.

Download Sudex and try every tool free for 30 days, on your own documents. No card needed.

Picture at full size