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
- On the Page Layout tab, under Orientation, choose Landscape.
- 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.
- 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
