Absolute cell reference

What is Absolute Cell Reference?
An absolute cell reference is a cell reference in a spreadsheet application that remains unchanged even if the shape or size of the spreadsheet is changed, or the reference is copied or moved to another cell or sheet.

Absolute cell references are important when referring to constant values in a table.

The absolute cell reference can also be referred to as the absolute reference.

The absolute cell reference can be used when a particular cell reference needs to be constant. Cell references are often used in formulas, charts, functions, and other commands. In some scenarios it becomes important to keep a cell reference constant when copying it to another cell.

An absolute cell reference always remains the same, no matter where it is copied and is often referred to with the symbol '$'. So if B10 is a cell in a table, B $ 10 $ is used to indicate that the reference is always on the 10th row in column B, even if the reference is copied to another cell or the table is on changed other way.

In vielen Tabellenkalkulationsprogrammen wie Excel kann eine Zellenreferenz durch Drücken der F4-Taste nach dem Eingeben der Zellenreferenz absolut gemacht werden. Die Spreadsheet wird die Zellenreferenz automatisch absolut machen. Wenn die Taste F4 kontinuierlich gedrückt wird, durchläuft das Tabellenkalkulationsprogramm alle absoluten Referenzmöglichkeiten. Wenn z. B. die Zellenreferenz als $ A1 eingegeben wird, ändert das kontinuierliche Drücken von F4 die Zellenreferenz auf A $ 1 und dann auf A1. Durch Drücken der Tastenkombination F4 werden die Referenzen direkt links vom Einfügepunkt geändert.