> ## Content Index
> Fetch the complete content index at: https://www.jeffsu.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# Google Sheets: This Table Trick Will Blow Your Mind
- URL: https://www.jeffsu.org/newsletter-182/
- Published: 2024-10-24T13:00:04.000Z
- Updated: 2025-09-05T12:49:38.000Z
- Description: #182
- Author: Jeff
- Tags: #newsletter, Google Sheets

*(you can easily* [*filter previous issues*](https://www.jeffsu.org/filter-previous-editions-by-app/) *by application!)*

---

Hey friends - A fellow Workspace Essentials subscriber, [Milton](https://www.linkedin.com/in/miltonslonim/?ref=jeffsu.org), is an expert with Google App Script automations and he has **kindly offered to build an automation for us!**

He’s open to suggestions on what automation most of us would like so please fill out [his Google Form here](https://docs.google.com/forms/d/e/1FAIpQLSc-vy2WtB59I0IQBk8YNkSIQyExsb%5FCKde1QA5gYTEZA2K-Qw/viewform?ref=jeffsu.org) if you have a request for him.

Onto today's productivity tip.

## Tables...again?

You might recall that a few months ago Google Sheets rolled out the [new Table feature](https://www.jeffsu.org/newsletter-169/), which allows us to convert an entire dataset into a beautifully formatted table in just 2 clicks.

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2024/10/Newsletter-gif-1.gif)

Today I’ll go over an extremely practical use case the new Table feature enables: **Referencing Tables within formulas.**

## Referencing Tables and Table columns

First, we can rename the table by clicking the dropdown next to the name:

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2024/10/image-5.png)

Now, I can use formulas to reference the entire Table or specific columns from within that Table.

In the example below, I’m using the basic =SUM() formula to add up all sales from the “Amount” column from within my “CustomerTable” table:

```html
=SUM(CustomerTable[Amount])

```

![](https://storage.ghost.io/c/db/85/db858a9d-1c4f-4993-8042-faa87b9bb3c1/content/images/2024/10/CleanShot-2024-10-23-at-13.57.20.gif)

As you might have noticed in the gif above, Google Sheet provides a very user-friendly dropdown menu of options after it sees we’re referencing a table!

## Keyboard shortcut

If you (like me) try to avoid using a mouse in Google Sheets to impress the ladies, we can use the following keyboard shortcuts to easily convert ranges to tables:

- Cmd+Opt+T for Mac
- Ctrl+Alt+T for Linux and Windows

---

**When you’re ready,** [here are all the ways how I can help](https://academy.jeffsu.org/?utm%5Fsource=newsletter&utm%5Fmedium=email&utm%5Fcampaign=footer).

**Was this forwarded to you?** [Join Workspace Essentials for free](https://www.jeffsu.org/newsletter/?utm%5Fsource=newsletter&utm%5Fmedium=email&utm%5Fcampaign=footer) 😉