Table reference improvements in Google Sheets

Since introducing tables in Google Sheets, we’ve made numerous improvements to ensure users are equipped with the tools they need to accelerate spreadsheet building. Table references, a way to refer to a table or parts of a table in a formula, are just one example of how tables reduce time spent manually formatting data. 

Today, we’re excited to announce updates to table references that enhance discoverability and usability. Specifically, users will now see: 

Improved table reference availability, which allows users to reference the items below across both single (e.g., =Table2[[#ALL],[Column 1]]) and multiple columns (e.g., =Table2[[#ALL],[Column 1]:[Column 2]] ): 

• Full table columns, including column headers, data, and footers (#ALL) 

• Table headers (#HEADERS) 

• Table footers (#TOTALS) 

• Table data, excluding headers and footers (#DATA)