How Do You Create An Absolute Cell Reference?
When you type in a formula in Microsoft Excel, the cell reference is not absolute. This means that when you copy the formula to another cell, the rows and columns change accordingly. You can make the cell reference absolute so the column or row does not change when the formula is copied to another cell. An absolute reference means that the formula will always use the values from the same cell regardless of the location of the cell where the formula is entered. Open Microsoft Excel and select the cell where you want to enter a formula. Type in a formula in the selected cell. For example, type in “=A1+B1” to add the value in cell A1 to the value in cell B1. In the current form, the reference to cell A1 or B1 is not absolute. Highlight the cell in the formula box (the one that follows “fx”) for which you want to make the cell reference absolute. Considering the example formula given above, if you want to make the cell reference for cell A1 absolute, highlight the cell by double-clicking “
