Top 20 Excel Shortcuts Every Financial Analyst Should Know
The right Excel shortcuts eliminate hours of repetitive work each week. Financial analysts who master keyboard shortcuts navigate models faster, format outputs more consistently, and catch formula errors more quickly than those who rely on menus and mouse clicks.
Top 20 Excel Shortcuts Every Financial Analyst Should Know
Whether you work in financial modeling, investment banking, FP&A, or corporate finance, these 20 Excel shortcuts cover the actions analysts perform most frequently. Mastering them will noticeably improve your speed and accuracy across nearly every workflow.
Ctrl + Arrow Keys — Jump to the edge of a data region.
Ctrl + Home — Return to cell A1.
Ctrl + Page Down — Move to the next worksheet.
Ctrl + Page Up — Move to the previous worksheet.
Ctrl + G — Open the Go To dialog to jump to a specific cell.
Shift + F11 — Insert a new worksheet.
Ctrl + D — Fill formulas or values down.
Ctrl + R — Fill formulas or values across.
Ctrl + Space — Select an entire column.
Shift + Space — Select an entire row.
Ctrl + Shift + + — Insert rows or columns.
Ctrl + - — Delete rows or columns.
Ctrl + Shift + 1 — Apply comma number formatting.
Ctrl + Shift + 5 — Apply percentage formatting.
Ctrl + B — Toggle bold formatting.
F2 — Edit the active cell formula.
Alt + = — Insert an AutoSum formula.
Ctrl + ` — Toggle formula view.
Ctrl + [ — Jump to precedent cells referenced in a formula.
F4 — Toggle absolute and relative cell references.
Navigation Shortcuts — Deeper Dive
The navigation shortcuts listed above cover everyday movement, but knowing when to reach for each one makes a real difference in large models with dozens of tabs and thousands of rows.
Ctrl + Arrow Keys — Best for scanning contiguous data blocks. In models with intentional blank rows (section breaks), combine with Shift to select as you go.
Ctrl + G (Go To) — Use Go To Special (Alt + S after opening) to select only formulas, constants, or blanks. This is invaluable for auditing a sheet you didn't build.
F5 — Opens the same Go To dialog as Ctrl + G. Some analysts prefer F5 because it's a single key press.
Ctrl + Page Down / Page Up — Cycle through worksheets sequentially. In models with a standard tab order (Assumptions → Revenue → Expenses → FS), this keeps navigation predictable.
Ctrl + Tab — Switch between open Excel workbooks, useful when referencing a comparable company file alongside your model.
Formatting Shortcuts — Deeper Dive
Consistent formatting signals professionalism and makes models easier to audit. These shortcuts help you apply standard conventions without opening the Format Cells dialog.
Ctrl + 1 — Opens the full Format Cells dialog. Use this when you need custom number formats (e.g., showing negatives in parentheses or adding "x" suffixes for multiples).
Ctrl + Shift + 1 — Applies comma-separated number formatting. Standard for most financial line items.
Ctrl + Shift + 4 — Applies currency formatting. Use sparingly — most models show currency only on the first and last rows of a section.
Ctrl + Shift + 5 — Applies percentage formatting. Essential for margins, growth rates, and return metrics.
Ctrl + B / Ctrl + U — Toggle bold and underline. In financial models, bold typically marks section headers and totals; single underline marks subtotals, double underline marks grand totals.
Formula Shortcuts — Deeper Dive
Formula shortcuts speed up model construction and are equally important for auditing models built by others. Understanding the full workflow around each shortcut maximizes their value.
F2 — Enters edit mode in the active cell. While editing, precedent cells are highlighted in color, giving you a quick visual audit without tracing arrows.
Ctrl + [ — Jumps directly to the source cell of a reference. Chain this shortcut to walk through a full dependency path from output back to assumption.
Ctrl + ] — The reverse of Ctrl + [. Jumps forward to cells that depend on the current cell, useful for understanding downstream impact.
F4 — Cycles through reference modes ($A$1 → A$1 → $A1 → A1). Press while editing a formula to lock row, column, or both without typing dollar signs manually.
Alt + M, P — Draws blue trace arrows showing all precedent cells visually on the sheet. Helpful when auditing complex formulas that reference multiple ranges across tabs.
Frequently Asked Questions
Related Training
Ready to Get Faster?
Start practicing with hands-on Excel drills designed for financial professionals.