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 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


Options

Formulas tab - "use table names in formulas"


Tables

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




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