# Reference cells

## 1. Reference an individual cell

To reference an individual cell, use standard spreadsheet notation. The only difference is that Quadratic allows negative axes; for negative notation, append `n` to the cell reference. Cells are, by default, relatively referenced. Use `$` notation to use absolute references.&#x20;

**Examples in the table below:**

<table><thead><tr><th width="219">Formula Notation</th><th>(x, y) coordinate plane equivalent </th><th data-hidden>(x, y) coordinate plane equivalent</th><th data-hidden></th></tr></thead><tbody><tr><td><code>A0</code></td><td>(0,0)</td><td>(0</td><td></td></tr><tr><td><code>A1</code></td><td>(0,1)</td><td></td><td></td></tr><tr><td><code>B1</code></td><td>(1,1)</td><td></td><td></td></tr><tr><td><code>An1</code></td><td>(0,-1)</td><td></td><td></td></tr><tr><td><code>nA1</code></td><td>(-1,1)</td><td></td><td></td></tr><tr><td><code>nAn1</code></td><td>(-1,-1)</td><td></td><td></td></tr></tbody></table>

## 2. Relative cell reference&#x20;

Individual cells and ranges are, by default, referenced relatively. E.g. copy-pasting `A1` to the following two rows will produce `A2`, and `A3` respectively.

To reference a range of cells relatively, use the traditional spreadsheet notation that separates two distinct cells using a semicolon as a delimiter, e.g. `A1:D3`

Cells in this notation are referenced relatively, so you can drag out a cell to replicate that formula relatively across your selection.&#x20;

<figure><img src="https://2438361843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Ff1Y5UzPF2x1oIzVJbUK8%2Fuploads%2FnpNpypjzP6fhxjjpzvh1%2F5.gif?alt=media&#x26;token=1dad38a1-4461-4b27-9a90-6d60063df5de" alt=""><figcaption></figcaption></figure>

## 3. Absolute cell references

To perform absolute cell references, use standard spreadsheet notation with `$`, for example  `$A$1:D3` - `A1` will be copied absolutely and `D3` will be copied relatively if you drag to replicate.

## 3. Reference across sheets

To reference the value from another sheet, use the sheet name in quotations with an `!`.

### Single cell

To reference cell F12 in a sheet named "Sheet 1" from a sheet named "Sheet 2" use:&#x20;

```formula
"Sheet 1"!F12
```

### Range of cells&#x20;

To reference cells F12 to F14 in Sheet 1 from Sheet 2, use:

```
"Sheet 1"!F12:F14
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.quadratichq.com/formulas/reference-cells.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
