# Cell references

As an extension to widget references, widget cell references are used in formula to retrieve the content of certain widget cells.

**Syntax**: <mark style="color:blue;">#page.widget!A1:B2</mark>

with

* <mark style="color:blue;">#page.name</mark> - Reference of the widget (see previous chapters)
* <mark style="color:blue;">A1</mark> - starting cell of the cell range, with
  * <mark style="color:blue;">A</mark>: column 1, <mark style="color:blue;">B</mark>: column 2, ...
  * <mark style="color:blue;">1</mark>: row 1, <mark style="color:blue;">2</mark>: row 2, ...
* <mark style="color:blue;">B2</mark> - ending cell of the cell range

**Selecting cell references in the formula editor**

While holding down the CTRL key, either a reference to a widget or to cells of a table widget can be inserted into the formula editor:

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-96d4f6cd36e7010e977daa46fb633dc0b034e224%2Fimage%20(71).png?alt=media" alt=""><figcaption></figcaption></figure>

#### Remarks

* Single cells can be referenced by a single click on an already selected widget reference (identified by a dotted frame).
* Multiple cells can be referenced by drag & drop across multiple cells.
* After clicking on a widget reference in the formula editor, the corresponding widget or widget cell(s) is marked by a dotted marching frame.

**Examples**

* <mark style="color:blue;">#table1!B3</mark> - returns the cell content of column 2 and row 3, of the widget with name table1
* <mark style="color:blue;">#table1!E</mark> - returns the content of the whole column 5
* <mark style="color:blue;">#table1!3</mark> - returns the content of the whole row 3
* <mark style="color:blue;">#table1!B3:D5</mark> - returns the cell range between column 2, row 3 and column 4, row 5.
* <mark style="color:blue;">#H5</mark> - returns the content of column 8, row 5 of the widget that executes the current formula.
* <mark style="color:blue;">#me!H5</mark> - returns the same as the previous example