a hidden row leaves no mark — a folded one leaves a ⊞, and the ⊞ opens again on request.
The regional tape came over from the analyst who left. Two of the three regions have had their monthly detail hidden outright — the row numbers jump, there is no ⊞ anywhere, and the region totals sum rows nobody can see. Put the detail back and rebuild it the house way: every region grouped, the detail folded out of the summary, and the one region the reviewer asked about left open.
Alt walks: tap Alt, release, then the letters in sequence — each key steps one ribbon menu. On a Mac, tap ⌥ and use the same letters (KeyTips, Excel 2024+).
Ctrl+Shift+9⌘⇧9 on macUnhide rows
Unhide rows an export or a previous owner collapsed — hidden detail is where errors hide too.
Alt h o w 1 2⌥ h o w 1 2 on macSet column width…
Exact column widths when autofit gives a ragged page — uniform width is part of house style.
Alt+Shift+→⌥⇧→ on macGroup rows/columns (outline)
Group detail rows so a reviewer can collapse to the summary — finished models ship with the detail folded.
Alt a h⌥ a h on macHide (fold) group detail
Collapse grouped detail to read the summary — the fold hides rows without deleting them.
Alt a j⌥ a j on macShow group detail
Ctrl+B⌘B on macBold
Bold marks structure: titles, total rows, anything the reviewer’s eye should land on first.
Alt h b p⌥ h b p on macTop border
Top border above a total row — the accounting ruling that says “this line sums the ones above.”
the par-setting sequence, straight through:
the gaps → ctrl+shift+9 (or alt h o u o) · the Amount column → alt h o w 12 (or alt h o i) · each region’s three detail rows → shift+alt+→ · alt a h folds · the Central total row → alt a j · the Consolidated line → ctrl+b · alt h b p · ctrl+s