Brought to you by:

Hi Reader,

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

January is a great time to sharpen your Google Sheets fundamentals: those small skills you build now that will save you time all year.

One of the best examples is learning a few simple keyboard shortcuts, which is what we're going to see today.

You probably already use Ctrl + C and Ctrl + V to copy and paste values, and can appreciate how this is quicker than clicking through menus.

Below I share 10 of the most impactful Google Sheets shortcuts that will have you zipping around your Sheets in no time. Using these shortcuts reduces friction in your work, helping you get results faster without breaking your flow.

See how many you already use below👇

➜ News

I.
​Set Google Forms to automatically stop accepting responses based on date and time or response count. No need for custom Apps Script solutions any longer. A great update.

​Read more here >>​

Brought to you by: Shortform Shortform: Escape AI Slop Shortform has the most comprehensive breakdowns of nonfiction books you can find, written by a team of professional readers and writers. Actual human beings and not AI generated junk-content. How refreshing! They have thousands of titles, so there's always something relevant. If you're constantly adding books to your list but rarely finishing them, Shortform might be worth checking out. Get a free trial and $50 off

➜ Sheets Tip #373: 10 Shortcut Keys Everyone Should Know

I still remember how awkward using shortcut keys felt at first. Honestly, using them was slower than just working with the mouse.

But after a few days, once the key combinations became automatic, they made a huge difference. I moved around my Sheet and selected ranges without taking my hands off the keyboard, which was much more efficient than constantly switching back and forth to the mouse.

Try these 10 powerful shortcuts to up your game:

1. Copy/Paste/Cut data

Mac: ⌘ + C / ⌘ + V / ⌘ + X

PC/Chromebook: Ctrl + C / Ctrl + V / Ctrl + X

2. Undo / Redo last action

Mac: ⌘ + Z / ⌘ + Y

PC/Chromebook: Ctrl + Z / Ctrl + Y

3. Edit the active cell

Mac/PC/Chromebook: F2

4. Clear All Formatting in a cell or range

Mac: ⌘ + \

PC/Chromebook: Ctrl + \

5. Insert the current date in a cell

Mac: ⌘ + ;

PC/Chromebook: Ctrl + ;

6. Select all the data in a table

Mac: ⌘ + A

PC/Chromebook: Ctrl + A

(Press it again to select the whole sheet.)

7. Find and Replace

Mac: ⌘ + Shift + H

PC/Chromebook: Ctrl + H

8. Move quickly to the last non-blank cell in a row or column:

Mac: ⌘ + ⬆⬇⬅➡ (arrow keys)

PC/Chromebook: Ctrl + ⬆⬇⬅➡

(Hold shift to also select the data.)

9. Highlight a column:

Mac/PC/Chromebook: Ctrl + Space Bar

10. Highlight a row:

Mac/PC/Chromebook: Shift + Space Bar
​

Today, I challenge you to use keyboard shortcuts.
​
It might feel clumsy at first, but persevere and it'll pay off in spades as you become more efficient in your work.
​
To see all of the available shortcuts, go to Help > Keyboard shortcuts

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

Have a great week!

Cheers,
Ben

P.S. Who's likely to be late to the Google Meet?​