Structured reference syntax

Structured references can access the data listed in the table below.

Reference	Description
#All	The whole table, including the header row and the total row (if any)
#Headers	Header row only
#Data	Data rows only
#Total	Total row only
@Column name OR @ OR #This row	Cell at the intersection of the current row and the specified column (implicit intersection)       #This row reference will automatically change to @

The table below provides examples of structured references.

** **	Entire table	Data only	Headers only	Totals only
Table Table1	Table1[#All]	Table1   Table1[#Data]	Table1[#Headers]	Table1[#Total]
Column N	Table1[[#All],[N]]	Table1[N]   Table1[[#Data],[N]]	Table1[[#Headers],[N]]	Table1[[#Total],[N]]
Columns N to M	Table1[[#All],[N]:[M]]	Table1[[N]:[M]]   Table1[[#Data],[N]:[M]]	Table1[[#Headers],[N]:[M]]	Table1[[#Total],[N]:[M]]