# A1 notation

how cells, ranges and worksheets are addressed in a formula.

A cell address is a column letter followed by a row number: A1, B7, XFD1048576. Columns run A..Z, then AA..AZ, and so on. A range is two addresses joined by a colon, A1:C10, and a whole column or row can be written B:B or 3:3.

A reference to another worksheet carries the sheet name and an exclamation mark: Data!B3. Names containing spaces are quoted: 'Q3 data'!B3.

A1 is a display convention, not the underlying identity. In deepcalc, rows and columns have stable ids underneath, and A1 text is translated at the boundary — which is why a reference keeps working after rows move, and why the journal can show exactly which edit rewrote a formula.

## related

absolute and relative references · structural edits

## navigate

- [all concepts](https://deepcalc.com/concepts.md)
- [function index](https://deepcalc.com/functions.md) · [error values](https://deepcalc.com/errors.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/concepts/a1-notation