Brought to you by:
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: β β 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. If you enjoyed this newsletter, please forward it to a friend who might enjoy it. Have a great week! Cheers, P.S. Medieval artist "you know how to paint a horse from the front, right...?"β |
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
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...
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...