Every office has the story: someone hits Print on a workbook and the printer produces forty-seven pages, one of which contains a single orphaned column called Notes. Excel is screen-first — the grid is infinite, paper isn’t — and the bridge between them is a small set of settings almost nobody is ever taught.

You still need paper more than the paperless office admits: board packs, warehouse pick lists, anything signed — and every PDF you send is “printing” by another name, governed by exactly the same settings. A mangled PDF is the modern 47-page disaster, and it goes to more people.

First: tell Excel what the page is

Excel doesn’t know what part of your sheet is the report — the data, workings and dashboard layers all look like cells to a printer. So say it explicitly. Select the report range → Page Layout → Print Area → Set Print Area. From now on, printing means this, not “everything I’ve ever typed, including the scratch column from March”.

Then switch View → Page Break Preview: the sheet with page edges drawn as blue lines, draggable. Ten seconds here answers “where will it break?” before any paper does — and dragging a stray column inside the nearest break is often the entire fix.

The scaling triangle

Page Layout holds the three-way trade — orientation, scaling, size. The everyday recipe for wide reports:

  1. Landscape. Most reports are wider than tall; most disasters are portrait.
  2. Width: 1 page (Scale to Fit), height: automatic — the sane setting: every column on every page, length flowing as it needs. It quietly prevents the orphaned-column page on its own.
  3. “Fit to one page” is a lie past a point — Excel achieves it by shrinking, and a 40-row sheet “fitting” one page prints at six-point type nobody can read. Below ~60% scale, change the content, not the zoom: fewer columns, a summary pivot instead of the detail, or an honest second page.
unplanned: 47 pages, one orphan "Notes" width: 1 page — tidy stack every column, every page; length flows
The orphan column isn't bad luck — it's an unset width. One setting turns the scatter into a stack.

The two settings that make multi-page reports professional

Print Titles (Page Layout → Print Titles → Rows to repeat at top). Point it at your header row, and pages two onward carry the column names — the paper equivalent of freeze panes, and the single biggest difference between a print-out that reads as a report and one that reads as an accident.

Headers and footers (Insert → Header & Footer): page numbers as Page 1 of ?, the print date, the file name. Paper has no version history — a date in the footer is the only provenance a print-out gets, and “which version is this?” is a question you can retire for the cost of one field code.

PDF, specifically

File → Export → PDF obeys everything above — set print area, scaling and titles first, then export, and check the result before sending (page two is where surprises live). For a recurring report, the layout work is one-time: settings live with the sheet, so next month is genuinely just Export. And when the “report” is really a live thing people should explore — filters to click, slicers to press — question the PDF itself: share the workbook or a dashboard instead. PDF is for documents; interactivity dies in it.

The deeper point is one you’ve met before on the path: presentation is a layer, deliberately designed, never an afterthought — the same discipline as honest charts and highlighting that spotlights, applied to the oldest output device there is.

Print area, landscape, width-one-page, repeated titles, dated footer. Five settings, ten minutes, and nobody ever hands you back your own report asking what column H was supposed to be.