2.0M
WAModeling confidence comes from knowing the shortcuts that make everything cleaner and faster. Nobody really teaches you these tricks, you’re usually expected to know them.
📌Ctrl + Shift + 1 (or !) — Clean number formatting
Instantly formats numbers with two decimals. No menu clicking.
PE analysts use this constantly.
📌Ctrl + Shift + $ — Currency formatting
Forget manually adding dollar signs — this does it perfectly, every time.
📌Ctrl + Shift + % — Percent formatting
If you work with margins, growth rates, or returns, this becomes your best friend.
📌Ctrl + Shift + Arrow Keys — Select entire data ranges
Jump and select thousands of cells in one move.
This is how analysts navigate giant models without touching the mouse.
📌Alt + = — Auto-Sum
Excel finds the range and sums it in one step.
Shaves minutes off every reconciliation.
📌F2 — Audit formulas quickly
Shows every input feeding the formula.
Perfect for catching errors before your VP does.
📌Ctrl + [ — Jump to precedent cells
Takes you directly to the input driving a number.
A lifesaver when you’re reviewing someone else’s model.
📌Ctrl + ] — Jump to dependent cells
Want to see where your number flows next? This takes you there instantly.
📌F4 — Anchor cells ($A$1)
The fastest way to lock rows, columns, or both.
If you build lookup formulas, this shortcut matters.
📌Alt + H + O + I — Auto-fit column width
Makes your model clean and readable in seconds.
Save this to save time.
#privateequity #finance #exceltips
@wallstwardrobe
