Absolute reference is used when we do not want to change the address of the cell while copying the formula to another cell. To use absolute reference in a cell, you need to add dollar ($) sign before the column and row number. For example: =$A$1+$A$2