Sheets Tip 332: Effortless Menu Navigation πŸ”


Brought to you by:


Hi Reader,

Welcome to the Google Sheets Tips newsletter #332, your Monday morning espresso, in spreadsheet form!

Today I have a quick and easy tip to share with you. It's a useful, but probably underused, feature of Google Sheets that makes it super easy to find things in the menus. Check it out below.

But before that, I want to share my latest AI + Sheets experiment.

At the end of last week, OpenAI launched Operator, an AI agent tool that can browse websites and perform actions on your behalf. In the demo, they showed it ordering show tickets and groceries.

I decided to test it out with an entirely different remit... involving Sheets of course.

​Check out this video where I let OpenAI take control of my spreadsheet and challenge it to create a pivot table, chart, and Apps Script automation, with as little input from me as possible:

video preview​

​


Brought to you by: Columns AI

Present Google Sheets with Impact and Joy

Tired of wrestling with #REF errors and dull, uninspiring visuals?

Let Columns AI revolutionize the way you work with spreadsheets.

✨ Summarize your data effortlessly.
🎨 Apply beautiful themes in a snap.
🌍 Share your polished results with confidence and joy.

Say goodbye to frustrationβ€”just chat with Columns AI and bring your spreadsheets to life!


➜ Sheets Tip 332: Menu Search Tool πŸ”

This is one of those incredibly useful features in Sheets that flies under the radar.

But once you know about it, and start using it, it makes you wonder how on earth you lived without it.

Sat here writing this newsletter, I'm saying to myself "I should use this more often!"

You'll find the Search the menus feature on the far left edge of the toolbar:

Click the magnifying glass to get started or press the shortcut key Alt + / (Windows, Chrome OS) or Option + / (Mac).

Type your intention into the popup window and it'll take you directly to that feature:

For example, suppose you want to apply custom number formatting.

Start typing and click on the relevant result:

You can drill down into any part of the toolbar, not just the top level options.

For example, you can quickly control the background fill color of a cell via this menu:

Don't sleep on this one!

It's worth investing a few minutes each day to lock in the muscle memory for the keyboard shortcut.

➜ Learn How To Build Internal Add-Ons

This week in Sheets Insiders, we have our third workshop in this mini Apps Script series, at 12pm Eastern time on Thursday 30th January.

We're going to publish our Sheets tool as an internal add-on, so it can be accessed and used from any other Sheet in our Google account.

Sign up here if you want to attend and are not yet registered.

​Register here​

See you on Thursday!


If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. Medieval artist "you know how to paint a horse from the front, right...?"​

Google Sheets Tips

Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.

Read more from Google Sheets Tips

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #354, your Monday morning espresso, in spreadsheet form! In last week's newsletter we compared wide and tall data, and what the pros and cons of each data "shape" were. Today, I want to show you how to move from one format to the other. How to transform tall data into wide data and vice versa. Going in one direction is easy. Going back, in the other direction, is less so. Find out which way round below! ➜ News I. It's...

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #353, your Monday morning espresso, in spreadsheet form! Today we're looking at the shape of data. It's foundational concept that underpins pivot tables and charts in Google Sheets. Once you understand the difference between wide data (for charts) and tall data (for pivot tables), you'll be off to the races! This week is all about the pros and cons of each data shape. Next week, I'll show you how to use formulas and...

video preview

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #352, your Monday morning espresso, in spreadsheet form! If you're a parent, then you've undoubtedly watched a lifetime's worth of Disney movies. You can appreciate the genius storytelling, rich characters and beautiful visuals. (But I'm sure you'd also be content to watch a film once, not 10 times!) Anyway, there's a scene in the Disney film Ratatouille where Remy bites into a strawberry and a piece of cheese at the...