hotkey.gg / drill library / formatting
◆ Formatting · drill · Excel Keyboard Fluency track

Set the alignment

alignment is information — numbers right, labels left, headers centered; and a long title centers ACROSS its columns, never merged.
The pipeline summary came back from the deal log with its alignment scrambled: the quarter headers slump left of the columns they head, the deal names float in the middle of the label column, and one quarter — plus the whole total line — reads left like text. Set it to house style, put the weight on the total, rule the header row, and center the title across the table without merging a single cell. The layout changes every run.
train this drill → par 22s · optimal 20 keys · keyboard only · free
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 a c⌥ h a c on macAlign center
Center headers over their columns — alignment is half of readability.
Alt h a l⌥ h a l on macAlign left
Left-align labels — text reads from the left, numbers from the right.
Alt h a r⌥ h a r on macAlign right
Right-align headers over number columns so they sit flush with their digits.
Ctrl+B⌘B on macBold
Bold marks structure: titles, total rows, anything the reviewer’s eye should land on first.
Alt h b o⌥ h b o on macBottom border
Bottom border under headers — rulings mark structure, not decoration.
Ctrl+1⌘1 on macOpen the Format Cells dialog
The master formatting dialog — number formats, alignment, borders in one place when a ribbon walk would take longer.
Ctrl+S⌘S on macSave
The optimal line
the par-setting sequence, straight through:
quarter headers B3:D3alt h a c · label column A4:A9alt h a l · figures B4:D9alt h a r · total row A9:D9ctrl+b · header row A3:D3alt h b o · title A1:D1ctrl+1 a · ctrl+s
More Formatting drills
Typeset the memo
Bold the header, unbold the imposter, italicize the memos, flag the discontinued line in r
The decimals pass
Take a comps page to the house decimal standard, and find the cell somebody hand-formatted
Fix the squeezed columns
A print page nobody can read — fit the labels to their content, hold the quarter block to
Rule off the schedule
Accounting rulings: line under headers, line above every total, outline the headline
← Decimals Autofit → all 74 drills
Excel is a registered trademark of Microsoft Corporation. hotkey.gg is independent and not affiliated with or endorsed by Microsoft. More: the shortcut compendium · all drills · about hotkey.gg.