Table Reference Enhancements in Google Sheets

What’s New

Google Sheets tables are becoming even more powerful! Table references, which let you efficiently refer to a table or specific parts of it in formulas, have been enhanced to boost usability and discoverability. These updates aim to streamline your workflow and reduce the time spent on manual formatting.

Here’s what’s improved:

• Enhanced Table Reference Options

Reference single or multiple columns more easily, with support for:

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

    • Only table headers (#HEADERS)

    • Only table footers (#TOTALS)

    • Only table data, excluding headers and footers (#DATA)

• Formula Suggestions

  • Receive smart suggestions for more robust formulas when overlapping ranges are detected.

• Formula Corrections

Get accurate corrections when an invalid table reference is entered.