Dolla Sign Y'all

Try writing the formula =A2*D2 into B2.

Select B2 and use the blue square to drag the formula from B2 down to B6 and you'll see a problem. When we drag a formula, the cell references get automatically updated, whether we want them to or not!

Try again, but make the first formula: =A2*$D$2

This formula says two important things:

• The $ in front of D says don't update the D.
• The $ in front of 2 says don't update the 2.

In this case, we only needed one of those, but better safe than sorry!

Sometimes you might want to allow the row to change, but not the column. Sometimes you might want to allow the column to change, but not the row. In these cases, place the $ accordingly.

Check It