{"id":2253,"date":"2026-10-01T10:48:52","date_gmt":"2026-10-01T10:48:52","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?page_id=2253"},"modified":"2026-10-31T12:13:18","modified_gmt":"2026-10-31T12:13:18","slug":"relative-and-absolute-cell-references","status":"publish","type":"page","link":"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/formulas\/relative-and-absolute-cell-references\/","title":{"rendered":"Relative and absolute cell references"},"content":{"rendered":"
\n
\n
\n
\n
\n\t\t\t\t\t\t[addtoany]<\/p>\n

Relative and absolute cell references<\/h1>\n

In formulas you can specify relative and absolute cell references. This only becomes significant when you copy formulas, which is something you do often in Excel.<\/p>\n

When you copy a relative cell reference from one cell to another, the reference will have the same relative position in both cells.<\/p>\n

\"CopyRelativeCellReferences\"<\/p>\n

When you copy an absolute cell reference from one cell to another, the reference will point to exactly the same cell in both cells.<\/p>\n

How to write relative and absolute cell references<\/h2>\n

Cell references are absolute if they are preceded by a dollar sign ($), otherwise they are relative.<\/p>\n

More specifically, every cell reference actually consists of a column reference and a row reference. Each of these can be made absolute or relative:<\/p>\n