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.
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Français (France)
French (France)
日本語
Japanese
한국어
Korean
Русский
Russian