Absolute References


Absolute references ensure that a formula always points to the same cell, even when copied or moved. This helps maintain consistent calculations across your workbook. This technique is important to use when you want to compose a formula that involves a range of data referenced against a set data point.

Syntax for absolute reference
  • To set an absolute reference use the $ before the row and column of a cell reference

CellA1becomes$A$1; RangeA1:A10becomes$A$1:$A$10

If you're stuck on something, feel free to message us via the support chat
[accessible via the app] or book a free support call below!