A structured reference is a special syntax for referencingExcel Tables.
Structured references work like regular cell references in formulas, but they are easier to read and understand.
Structured references are also dynamic, and adjust automatically when data is added or removed from an Excel Table.
Excel will enter structured references automatically when you reference parts of a table with point and click.
This behavior is controlled by the preference “Use table names in formulas”.
References to multiple columns are absolute and will not change when formulas are copied.
