Stockertim Dictionary · Technology
Cell reference
Also called cell references, cell address, A1 reference
In short
The address of a spreadsheet cell, a column letter followed by a row number such as B3, which a formula uses to read the value held there.
- Beginner
- Concept
- Checked
In detail
Every cell in a spreadsheet grid has an address made from its column and its row. Columns are lettered A to Z, then AA, AB and onwards; rows are numbered from 1. The cell where column C meets row 7 is C7. A formula that contains C7 does not store the number in that cell: it stores the address, and reads whatever value sits there each time the sheet recalculates.
References can point further afield. A colon joins two corners into a range, so B2:B13 means twelve cells in one column and A1:D20 a block of four columns. An exclamation mark reaches another sheet, as in Costs!B4, and quotation marks of the single kind wrap a sheet name containing spaces, as in 'March sales'!C2. References to other workbooks also exist, but they break easily when files are moved or renamed.
Because formulas hold addresses rather than values, one change in an input cell flows through every calculation that depends on it. That is the main strength of a spreadsheet and the reason its results can be audited: a reviewer can trace each figure back to its inputs. Most programs can show the trail with arrows for precedents and dependents.
The weakness is that an address is only as good as the layout behind it. Pointing at the wrong row, a total that stops one row short of the data, or a reference left behind after rows are deleted produces figures that look normal. A deleted cell turns its references into a #REF! error, which at least is visible.
Worked example
A café in Accra lists the price of a sandwich in B2 and the number sold in C2, and puts the formula =B2*C2 in D2.
- With 8 in B2 and 25 in C2, the formula reads both cells: 8 × 25 = 200
- The owner corrects the price in B2 to 9; D2 recalculates at once: 9 × 25 = 225
D2 always shows price times quantity for whatever values the two cells hold.
In practice
Analysts check a model by clicking into key totals and following the references back to the raw inputs. Clear layouts, with inputs in one place and labelled, make the references easy to follow and mistakes easy to spot.
Watch out
- A total such as
=SUM(B2:B12)does not grow when a new row is added below row 12; check that ranges cover every row of data. - Deleting a row or sheet that a formula uses gives
#REF!, which spreads to every dependent cell.
Learn it properly
Official sources
- The AQuA Book: guidance on producing quality analysis for government · HM Treasury
- The Government Data Quality Framework · UK Government Data Quality Hub
Facts last checked on 9 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.