# 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.

Table of Contents

### 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.

Rate this post