Table reference improvements in Google Sheets

Was sich ändert

Since introducing Tabellen 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)

Formula suggestions, which help you identify formulas that could be more robust. For example, if a user types a working formula that overlaps with a table range, a table reference suggestion will show.

Formula corrections for table references, which show a formula correction with a proper table reference when a formula is written incorrectly.

Erste Schritte

Admins: There is no admin control for this feature.
Endverbraucher: Besuchen Sie das Hilfezentrum und erfahren Sie mehr über using table references in Google Sheets.

Tempo der Einführung

Rapid-Release-Bereiche: Gradual rollout (up to 15 days for feature visibility) starting on November 19, 2024
Geplante Freigabedomänen: Gradual rollout (up to 15 days for feature visibility) starting on December 10, 2024