> For the complete documentation index, see [llms.txt](https://books-gyansetu.gitbook.io/advanced-excel/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://books-gyansetu.gitbook.io/advanced-excel/absolute-and-relative-referencing.md).

# Absolute & Relative Referencing

**Absolute & Relative Referencing** 

There are two types of cell references: **relative** and **absolute**. Relative and absolute references behave differently when copied and filled to other cells. Relative references **change** when a formula is copied to another cell. Absolute references, on the other hand, remain **constant**, no matter where they are copied.

**Relative Reference**

> C1 = A1 + B1

**Absolute Reference**

> C1 = $A$1 + $B$1

{% file src="/files/-LRfLKa6coh8Ebb8g7ao" %}
Example of Absolute & Relative Reference
{% endfile %}