Structured reference

Excel glossary definition

A reference that uses table and column names instead of cell addresses.

Definition

Available inside Excel Tables. For example, =SUM(Sales[Amount]) refers to the Amount column of the Sales table and updates automatically when rows are added.

Back to Excel glossary