What is Absolute Cell Reference in Excel?
Absolute Cell Reference or Absolute Reference is used to lock a cell address.
It locks up the references so that the cell address does not change while copying the formula.
The absolute cell reference is identified by the dollar sign ($).
You can apply the absolute cell reference by adding the dollar sign ($) before the column and row numbers.
Keyboard Shortcut
Press F4 or press Fn+F4 (if the F4 is preoccupied with another function).
Explore: 65 Shortcut Keys in Excel
Example of Absolute Cell Reference
Some of the examples of absolute cell references are $A$1, $G$5, $H$2, etc.
How to Use Absolute Cell Reference
Here is a list of items (column A) and their individual prices (column B). Each of the items is brought in 5 pieces (row 8). I am going to calculate the total prices (column C) of each item.
Step_1: Add absolute cell reference ($ sign) to cell B8 and the first item price.
=$B$8*B2
Step_2: Press ENTER.
Step_3: Double-click the Fill Handle to copy the formula down.
All the item prices are multiplied by the quantity.
Conclusion
The absolute cell reference is a very useful referencing system where you have to fix the cell address. I hope you have got an overall idea about absolute cell reference and its usage.
Excel Glossary | Cell Reference | Reference Style | Circular Reference | Relative Cell Reference | Mixed Cell Reference
