11/09/2026
๐๐๐ฒ ๐๐๐ซ๐จ๐ฅ๐ข๐ง๐ข๐๐ง๐ฌ! Welcome back to ๐บ๐๐๐๐๐
๐ช๐๐๐๐ ๐ญ๐๐๐
๐๐! ๐
Ever dragged a formula down a column and watched it break because a cell reference shifted when it shouldn't have? ๐ฉ Stop re-typing formulas row by row โ lock cells in place with Absolute References ($) in both ๐๐ข๐๐ซ๐จ๐ฌ๐จ๐๐ญ ๐๐ฑ๐๐๐ฅ ๐๐ง๐ ๐๐จ๐จ๐ ๐ฅ๐ ๐๐ก๐๐๐ญ๐ฌ!
โ ๏ธ The Problem:
By default, when you copy a formula like =A2*B1 down or across, Excel and Sheets shift both references relatively โ so B1 (say, your interest rate) turns into B2, B3, and so on, pulling from empty cells instead of your actual rate.
โ
The Fix: Add a $ sign
1๏ธโฃ Identify the cell you want to "lock": the one that should stay fixed no matter where you copy the formula (e.g., a single interest rate in B1).
2๏ธโฃ Add dollar signs before the column and row: change B1 to $B$1. This locks both the column and the row.
3๏ธโฃ Copy or drag your formula across as many cells as you need โ $B$1 will stay the same in every copy, while other references (like A2) still adjust normally.
4๏ธโฃ Shortcut: Click on the cell reference inside your formula and press F4 (Excel) to cycle through absolute/relative options instantly โ no need to type the $ manually!
๐๐ซ๐จ ๐๐ข๐ฉ: This is a lifesaver for finance work specifically โ building loan schedules, discounting cash flows, or running any model where one assumption (rate, tax %, inflation) needs to apply to every row without breaking!
Small trick, huge time save โ hit save so you don't lose it before your next model is due. ๐ Got a shortcut that changed the way you spreadsheet? Drop it in the comments, and it might just be next week's !
$LockTrick
