Cells and formulas · Lock it with $Works in: all current Excel versions, Google Sheets

Some cells shouldn't move

Sometimes every row needs the same cell, like one tax rate in K2. Fill =I2*K2 down and the copy in J3 looks at K3, which is empty.

A $ in front of the column letter and in front of the row number locks the reference: $K$2 stays K2 wherever you copy it. That's an absolute reference. While editing a reference, press F4 (Excel for Windows, and Google Sheets; Fn+F4 on a Mac in Sheets) or Command+T (Excel for Mac) to add the dollar signs.

Syntax
$K$2
Common mistakes
  • Forgetting the $: the copies below look at K3, K4… and show $0.00.
  • Locking the wrong cell: =$I$2*K2 keeps every row on the first order.

Tap Try it to work out the tax on every order.

ABCDEFGHIJK
1OrderDateCustomerProductCategoryQtyPriceStatusTotalTaxTax rate
210012 Mar 2026Mara OkaforMonsteraPlants1$34.00Shipped$34.008%
310022 Mar 2026Jonas LindTerracotta potPots3$12.50Shipped$37.50
410033 Mar 2026Priya RamanSnake plantPlants2$22.00Shipped$44.00
510044 Mar 2026Tomás RuizWatering canTools1$18.00Pending$18.00
610055 Mar 2026Elif DemirFernPlants4$9.50Shipped$38.00
710065 Mar 2026Mara OkaforPotting mixSoil2$7.25Returned$14.50
810076 Mar 2026Kenji MoriPruning shearsTools1$24.00Shipped$24.00
910087 Mar 2026Ines VargaCeramic potPots2$19.00Pending$38.00
1010098 Mar 2026Jonas LindMonsteraPlants1$34.00Shipped$34.00
1110109 Mar 2026Sofia RossiFernPlants6$9.50Shipped$57.00
12101110 Mar 2026Priya RamanPotting mixSoil5$7.25Shipped$36.25
13101211 Mar 2026Leo BrandtSnake plantPlants1$22.00Pending$22.00

Tap Try it to type =I2*$K$2 into J2.

Go deeper: Absolute and relative references