◆ Formatting · drill · Excel Keyboard Fluency track
The ruling pass
the ruling pass is a checklist, not a vibe — four conventions, every page.
The desk shipped this schedule as done — the ruling pass disagrees. This page carries exactly 4 breaks against the house conventions: headers ruled underneath, a line above every total, the answer line bold and ruled, the headline in an outside border. The other conventions still hold. Read the page against the standard, find all 4 breaks, repair them, and save.
The shortcuts in this drill
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+).
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.”
Ctrl+B⌘B on macBold
Bold marks structure: titles, total rows, anything the reviewer’s eye should land on first.
Alt h b s⌥ h b s on macOutside borders
OUTSIDE border (S for outSide) — ONE frame around the selection’s perimeter, interior clean. The finished-table look; A is the grid of lines, S is the frame.
The optimal line
the par-setting sequence, straight through:
the standard, chord for chord — header rule UNDER: alt h b o · a line ABOVE each total and the answer line: alt h b p · the answer line bold: ctrl+b · the headline outlined: alt h b s. Exactly 4 broke this run — fix those, then ctrl+s.
More Formatting drills