hotkey.gg / drill library / foundations
◆ Foundations · drill · Excel Keyboard Fluency track

Rebuild the schedule

structure ops inherit — a new row dresses like the one above it, a new column like the one to its left.
The opex schedule took structural damage: one expense line never made it in (staged below the block), a PLACEHOLDER row is squatting where data belongs, a DRAFT column is still lodged between the quarters, and one quarter is missing entirely (staged at the side). The red notes mark where the new row and the new column go. Rebuild it — rows first, then columns. Every SUM on the page is live and recalculates as the structure moves. Watch what a fresh row or column is wearing the moment it arrives.
train this drill → par 30s · optimal 29 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+).
Shift+Space⇧Space on macSelect the entire row
Select the whole row — pair it with Ctrl+Shift+= to insert, Ctrl+- to delete.
Ctrl++⌘+ on mac
Ctrl+C⌘C on macCopy
Copy starts almost every hand-off — grab a finished block once, then place it in the summary, the deck, or next quarter’s column.
Ctrl+V⌘V on macPaste
Plain paste brings everything: values, formulas, formats. Reach for Paste Special when you only want part of it.
Alt h k⌥ h k on macApply comma style
Comma style on any block of raw numbers — readable thousands in three keys.
Alt h f c⌥ h f c on macFont color
Font color: blue inputs, black formulas — the oldest convention in banking models, still enforced.
Ctrl+-⌘- on macDelete rows / columns — select the whole row/column 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 optimal line
the par-setting sequence, straight through:
row below Payroll · shift+space · ctrl+plus · paste the staged line · alt h k + alt h f c blue · PLACEHOLDER row · shift+space ctrl+minus · Total row alt h b p · DRAFT column · ctrl+space ctrl+minus · Q3 column · ctrl+space ctrl+plus · paste the staged Q2 · ctrl+s
More Foundations drills
Navigate and select
One long switchback corridor through solid walls: every straightaway is a single shot, eve
Fill down, fill right
A quarterly operating build off the revenue feed — three cost lines across the year, EBITD
Paste Special everything
The full paste-special toolkit — transpose, divide, multiply, formats, values
Assemble and format the summary
COPY what stays, CUT what moves — the feeds run in segment order; dress the table as you g
← Block Select Repair → 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.