Sheets Tutorial

Green Google Sheets icon. Link to new google sheet

WHAT DOES IT DO?

Google Sheets is an spreadsheet program that students and teachers can use to collect and analyze data.

Get Support

A green Google Sheets icon next to the text "Google Sheets: Contact an HSD TOSA for integration ideas," all enclosed in a rounded gray border. Links to email techteachgrowteam

Product Updates

An animated screen recording of a Google Sheets "Project Tracker" table. The table features columns for Task, Priority, Status, Deadline, and Outcome, using dropdown menus and color-coded chips. The animation shows the table interface, including the new table header and formatting options.

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)

Screenshot of a Google Sheet showing a "Hotels" table with columns for ID, Hotel name, Level, Key Amenities, and Price. In cell G10, a formula is being entered: =SUM(Hotels[Price]). A helper box highlights the "Price" column in the table, demonstrating how to use structured table references instead of standard cell ranges.

Resource Guide

Report abuse