Structured reference in Excel tables

A structured reference names a table and a column instead of a range, so the reference grows and shrinks with the table rather than staying fixed.

Structured references read well and survive inserted rows, which makes them a better choice than a fixed range in a model that will be extended.

A copy pasted outside the table loses the structure, so a review should check whether a table’s formulas all still live inside it.

More definitions

Twenty-five terms a reviewer needs, each in one sentence followed by the context that matters.