Structured reference syntax

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

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