---
title: "Add relative or absolute links"
description: "Our solution allows you to easily change the cell references to relative and absolute ones"
url: https://help-takeoff.kreo.net/en/articles/5488000-add-relative-or-absolute-links
collection: "Using in the spreadsheet"
updated: 2025-09-22
language: en
alternates: [fr]
---

# Add relative or absolute links

Our solution allows you to easily change the cell references to relative and absolute ones

# **Introduction**

In Kreo 2D Takeoff, you can easily change the cell references to relative and absolute ones.

**Absolute links** allow you to fix a row or column to which the formula should refer.

**Relative links** change automatically when you copy a formula along a range of cells, both vertically and horizontally.

# **How to add relative or absolute links?**

To add a relative or absolute link, right-click on the link itself in the input line and select the option that suits you best out of the following:

$A$1 — absolute column and absolute row

$A1 — absolute column and relative row

A$1 — relative column and absolute row

  
where **1** is the row's name, and **A** is the column's name.

📝 **Note!**

_By inserting the_ **_"F4"_** _in the input line right after the relevant link, you are able to change the link itself._

![](https://staticfiles.gleap.io/helpcenter/6874f791a81bb9196b315e05/20250715090941_7300.png)