Hi Reader,

Welcome to the Google Sheets Tips newsletter #200!

Two hundred!!

What started as an experiment with a single email on 30th April 2018 has wildly exceeded my expectations and now reaches 36,000 of you every Monday morning. I’m speechless and humbled when I consider that number.

Thank you for reading!

Here’s to the next 200 espresso’s, in spreadsheet form!

➜ Can you spare a couple of minutes?

I’d love to know more about you, so I can help you better.

Specifically, I'd love to hear how you use Google Sheets, what challenges you face, and what topics you’d like to learn in the future:

​Take the 2-minute audience survey​

Everyone who takes the course will get a 25% discount coupon to use with any of my courses.

I’ll also pick three lucky winners to get a free copy of my upcoming course: The QUERY Function in Google Sheets

This course launches next month and will help you work better with data and master the most powerful function in Google Sheets.

_______

➜ News

I.
​Intelligent corrections for formulas in Google Sheets are now available. I'm excited to see what this brings. Note, it might take up to 15 days to see this in your Sheets.

​Intelligent corrections for formulas in Google Sheets​

_______

➜ Google Sheets Tip #200:

Here is your Google Sheets tip, which you can think of as your Monday morning espresso, in spreadsheet form.

I started the weekly newsletter series with my top 5 Google Sheet shortcuts (see email #1), so I thought it would be neat to come full circle and revisit shortcuts today.

Using shortcuts will make you more efficient in your spreadsheet work. It might feel clumsy at first, but the effort is worth it. Even learning a few will make a big difference.

Here are 5 shortcuts worth learning:

1. Clear formatting

Ctrl + \ (Windows, Chrome OS)

⌘ + \ (Mac)

2. Toggle relative and absolute references in formulas

Use F4 to toggle the $ signs on/off your references.

3. Paste as values

Turn formula outputs into static values by using the paste-as-values option:

Ctrl + Shift + v (Windows, Chrome OS)

⌘ + Shift + v (Mac)

4. Open filter drop-down menus

Ctrl + Alt + R (Windows, Chrome OS)

Ctrl + ⌘ + R (Mac)

5. Create a new Google Sheet from Drive

Instantly create a new Google Sheet from a Drive folder with this handy shortcut:

Shift + S

What are your top 5?

_______

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

Have a great week!

Cheers,
Ben

P.S. Why ostriches don't work at lumber mills...​