You can create an absolute cell reference by placing a in front of both the column letter and the row number of the cell address.

Dollar sign ($)

Explanation:

When working with formulas in microsoft excel, we may find ourselves copying formulas accross different cells, this is done by cell referencing and there two types of cell references, the absolute and relative. An absolute reference to a cell simply means that the cell is "locked" and its rows and columns are not going to change when they are copied. So when an absolute referenced formula is copied to another cell, it remains constant. This is unlike the relative reference where the formula changes relative to the new location where it is copied to. To accomplish an absolute reference, the dollar sign ($) is placed in the front of both the letter and number representing the column and row respectively like this $A$5.

answer; availability;