Excel Shortcuts Every Investment Banking Analyst Should Know
The gap between a first-year who's still reaching for the mouse and one who isn't comes down almost entirely to a few dozen keyboard shortcuts. Here they are, organized by what you're actually doing at your desk.
Test yourself on a real interview question ↓This isn't about being fast for its own sake. It's about not breaking focus.
Every reach for the mouse is a small interruption to whatever you were actually thinking about in the model. Do it a hundred times a day and it adds up to a lot of lost thread.
The shortcuts below are grouped the same way CapTableClash's own Excel Shortcut mode organizes them: navigation, selection, formatting, formulas, and editing.
Navigation
Ctrl + ArrowJump to the edge of the current data region in that direction.Ctrl + HomeGo to cell A1.Ctrl + EndGo to the last used cell on the sheet.Ctrl + PageDown / PageUpMove to the next / previous sheet in the workbook.F5 (or Ctrl + G)Open Go To and jump straight to a specific cell or named range.Selection
Ctrl + Shift + ArrowExtend the selection to the edge of the data region.Ctrl + SpaceSelect the entire column.Shift + SpaceSelect the entire row.Ctrl + ASelect the current data region (press again for the whole sheet).Ctrl + Shift + EndExtend the selection from the active cell to the last used cell.Formatting
Ctrl + 1Open Format Cells.Ctrl + B / I / UBold / italic / underline the selection.Ctrl + Shift + 4Apply currency format.Ctrl + Shift + 5Apply percentage format.Ctrl + Shift + 1Apply number format (two decimals, thousands separator).Ctrl + Shift + 3Apply date format.Formulas
F2Edit the active cell directly.F4While editing a formula, cycle a cell reference through absolute and relative ($A$1, A$1, $A1, A1).Alt + =AutoSum the adjacent range.Ctrl + `Toggle showing formulas instead of their calculated values. It's useful for auditing someone else's model fast.F9Force a full recalculation of the workbook.Editing & keytip sequences
Beyond the standard Ctrl-based shortcuts, Excel's older Alt-key “keytip” system still works and covers commands that never got a dedicated chord. Tap Alt, release it, then press the letters shown for each ribbon command in sequence. For example, Alt, H, B, O applies a bottom border without ever touching the mouse.
Ctrl + Z / Ctrl + YUndo / redo.Ctrl + ;Insert today's date as a static value.Ctrl + Shift + ;Insert the current time as a static value.Alt, H, B, OApply a bottom border (keytip sequence).Alt, H, 1Bold the selection (keytip alternative to Ctrl+B).A list you read once doesn't make these automatic. Repetition under a little pressure does, the same way everything else becomes automatic.
CapTableClash's Excel Shortcut mode times you against the same shortcuts above on a real simulated sheet. No mouse allowed.
Try a real question
The same question engine and clock a real duel uses. No account, no signup, nothing saved.