The dollar sign ($) lets you fix chosen values in a formula. For example, if you wish the value in cell B3 to remain unchanged when copying the formula to other cells, add dollar signs in front of both the column and the row reference ($B$3). However, sometimes you may need to fix only one reference. In this case, you should only add one dollar sign in front of either the column or the row reference. Like this: • $B3 – the row reference can change when the formula is copied into other cells, but the column reference can’t. • B$3 – the column reference can change, but the row reference is fixed.