An absolute reference means when a cell reference is locked or fixed. So, when you want to keep your cell reference the same while copying or AutoFill a formula, absolute reference is here for you.
How to Create Absolute Reference in Excel
To create an absolute cell reference in Excel, you need to add a dollar ($) sign before the row and the column number. Let’s say, you want to lock the C3 cell. So, the C3 cell will need to appear like this $C$3.
Moreover, if you write C$3, the row number will not change while copying the formula, but the column will.
Besides, if you write $C3, the column reference will be locked but the row will be a relative cell reference. To make a cell locked, you must write it $C$3.
Example to Use Absolute Reference in Excel
For example, you want to multiply the working hours for each employee by a fixed hourly rate of $10. So, lock the C3 cell by adding $ sign ($C$3) and multiply it with another cell. When you copy the same formula along the Payment column, you can see that each cell in column C is multiplied by the cell value in C3.
