Structured References

Added in 2007
The syntax was changed slightly in Excel 2010.
Easier to read than Standard References (A1, B2, B1:C20).
Makes it simpler to work with cell references inside tables
Allows table formulas to be very dynamic
They adjust automatically when data is added or removed
Structured references automatically adjust as rows are added or removed from the table.

Structured references will be inserted automatically when you click or select different parts of a table instead of typing the explicit cell references

Allows you to reference columns, header rows and total rows without using the explicit cell references (A1 or R1C1 notation)

The combination of the table name and the column name is called a structured reference


Formulas tab - "use table names in formulas"


The header row should always be displayed
Creating tables (Insert > Table) (Ctrl + T)
Create table dialog box
select whole table - top left corner
how to select individual columns

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext