profile

Google Sheets Tips

Sheets Tip 323: Browser Shortcuts

Published about 2 months ago • 1 min read

Brought to you by:


Hi Reader,

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

Today's tip is a simple one, but it's super useful.

I first shared it six(!) years ago, almost to the day, in tip 23.

I'm bringing you an updated version of the tip today, with the addition of a shortcut for Gemini AI.

Brought to you by: Formulas HQ

Make Sheets Easy Again

We’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Work smarter, not harder, with AI-powered formula generation.

➜ News

I.
​This article from The Guardian shares the best bloopers from 40 years of Excel spreadsheet errors. Although focused on Excel, there are undoubtedly similar Sheets bloopers out there too.

​Read Microsoft Excel’s bloopers reel​

➜ Sheets Tip #323: Browser Shortcuts

Type these shortcuts into your web browser address bar to instantly create new Google Workspace apps:

sheet.new

doc.new

slide.new

form.new

(The plural app name also works e.g. sheets.new)

This is what it looks like in your browser:

​

And, new for 2024, we can use Gemini AI directly from the browser address bar. Type:

@gemini

(this one requires "@" in front)

And then you can type in your prompt:

If you're not logged into your Google account you'll be prompted to do that first.

➜ Sheets Insiders Live Session

This week in Sheets Insiders, we're looking at the family of amazing data analysis formulas that no-one knows about (the Database functions).

In addition to the newsletter, we have a live session covering this topic on Thursday, November 7th at 12 pm Eastern Time (that's noon in New York timezone).

I'll record it for those who can't make it live.

​Register here​

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

Have a great week!

Cheers,
Ben

P.S. Why you only get sick on work days​

Google Sheets Tips

by Ben Collins

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

Hi Reader, Welcome to the Google Sheets Tips newsletter #328, your Monday morning espresso, in spreadsheet form! This is the last Google Sheets Tips newsletter for 2024. A big thank you for being part of this journey and reading these tips. Your Monday-morning-espressos-in-spreadsheet-form will return on the 6th of January 2025. In the meantime, I wish you all a wonderful holiday season with your loved ones. Tip 328—creating a 2025 calendar with a formula—is found below, but first: ➜ 2024 In...

11 days ago • 2 min read

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #327, your Monday morning espresso, in spreadsheet form! Recently a reader asked about a problem importing data from one Sheet to another when the sheet names were changing. Below, we look at how to solve this and see yet another benefit of the new Google Tables feature. My family and I spent the weekend at Fairmont University in West Virginia, where my eldest son was competing in a Lego robotics competition. With his...

18 days ago • 2 min read
Column stats tool in Google Sheets

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #326, your Monday morning espresso, in spreadsheet form! Last week, we looked at the concept of "walking the first row" to understand your data. This week, we're pairing that with the Column Stats tool. Using both of these techniques will ensure you have a full understanding of what's in your dataset and a good sense of the metrics (e.g. row count). Check it out below! Also, there is no Google Sheets Tips email next...

about 1 month ago • 2 min read