Skip to content
Using the $ sign in excel formula to fix the cell reference
If you copy and paste a cell containing formula or drag the cell, the formula reference will also change and move accordingly. For example, if you want to calculate the amount of sales to each customer based on the number of units sold when the sales price is fixed, and the sales price is updated in one cell (B3), you can fix the cell reference of sales price (B3) by putting $ sign like ($B$3) and copy or drag the formula. You can also put the $ sign in formula cell reference by using function key F4.