Always refers to a cell in a specific location. When a formula is copied or filled to other cells, the formula's cell references ...

Always refers to a cell in a specific location. When a formula is copied or filled to other cells, the formula's cell references remain fixed. For example, suppose a formula in cell B2 that references cell A1. If you copy that formula to cell B3, the cell reference remains $A$1.