Paste Special mastery.
The single most-used Excel shortcut in financial modeling. The 6 variants every modeler should know — values, formulas, formats, transpose, multiply, link — and when to reach for each. Free 4-page PDF + 7-minute video walkthrough.
What’s inside.
- Paste Values — when to lock in a calculated number, and the senior-modeler protocol for not breaking the file
- Paste Formulas — without absolute-reference quirks; the F4 dance for keeping references intact
- Paste Formats — the fastest way to align number formatting across a model without manual tweaking
- Paste Transpose — flipping rows to columns (and back) without manually retyping; the operations modelers use it for
- Paste Multiply / Divide — rescaling a range by a single factor in one operation
- Paste Link — when to use it, when it’ll cause you a circular-reference headache later
- The keyboard shortcut —
Alt + E + S + V(and the 2016+ alternative); muscle memory drills
Get the PDF + video.
Enter your email. The PDF arrives immediately; the 7-minute video walkthrough is linked inside. One email, one purpose.
Pulled from Module 1 of REIT Modeling — the self-paced REIT modeling course.