6 Killer Productivity Tips for Google Sheets

Let’s kick of this post with one of the all-time top Google Sheet productivity tips:

1. Shortcuts

Google Sheets Shortcuts

Use keyboard shortcuts to work more efficiently. 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

Here are my top shortcuts:

Clear All Formatting in a cell or range

Mac: ⌘ + \
PC/Chromebook: Ctrl + \

Insert the current date in a cell

Mac: ⌘ + ;
PC/Chromebook: Ctrl + ;

Select all the data in a table

Mac: ⌘ + A
PC/Chromebook: Ctrl + A

Find and Replace

Mac: ⌘ + Shift + H
PC/Chromebook: Ctrl + H

Open the drop-down menu on filtered cell

Mac: Ctrl + ⌘ + R
PC/Chromebook: Ctrl + Alt + R

Quickly repeat your previous action in a new cell

Mac: F4
PC/Chromebook: F4

(Note, this will also copy-paste static values, but not formulas. If you type some text into a cell and then hit F4 in a different cell before doing anything else, it’ll copy that same text to the new cell. This quirk only works cell to cell, not cell to range though.)

Today, I challenge you to use keyboard shortcuts!

Click here for the Google Documentation for shortcuts.

2. Stay informed of changes to a Google Sheet

Stay informed of changes to a Google Sheet by setting Notification Rules to send you an email.

You’ll find it under this menu: Tools > Notification rules…

Here you can decide what should trigger a notification and how they should be delivered (immediately or a daily summary):

Google Sheets Notifications

3. Alert someone to a specific comment

Comments are one of the killer collaboration features embedded in Google Sheets.

You can alert someone to a specific comment in a Google Sheet by adding their email address.

You add a comment by right-clicking a cell and choosing Insert comment, or through the menu Insert > Comment

Insert comment in Google Sheets

You can then tag specific people in each comment if you wish, which means they’ll receive an alert that they’ve been mentioned in a comment.

For example, you might tag Jenny in Finance to ask her to check if your calculation is correct. It’s way easier than trying to explain something via email!

You tag someone in a comment very easily by typing a “+” or “@” in the comment box, and then adding the email address of the person you want to notify. As you start typing, Google will auto-suggest email addresses from your contacts list.

Email alert in Comment in Google Sheets

4. Create hyperlinks within your Google Sheets

Create hyperlinks within your Google Sheets to make it easier to find information.

You can add hyperlinks to different tabs or even directly to individual cells within your Google Sheets.

They’re super easy to create. You don’t even have to write any formulas yourself. Simply:

  1. Right click on the cell that you want to turn into a clickable hyperlink
  2. Click “Insert link”
  3. Choose either “Sheets in this spreadsheet” or “Select a range of cells to link”

That’s it!

Hyperlink in Google Sheets

Here’s a few examples of how you could use this:

  • Add a Home button to every tab in your Sheet so you can quickly get back to the first tab
  • Create a “table of contents” for your Sheet
  • Link to important calculation cells so they can be easily accessed

5. Quickly Freeze Panes

Quickly drag the column header row down to freeze panes.

Freeze panes is a useful and simple technique to lock the top row (or rows) of your spreadsheet, so that they remain in view even as you scroll down your datasets. You’re effectively anchoring them in place.

It’s really useful because you can keep your column headings in view as you move about your data.

Traditionally, you freeze panes through the View > Freeze menu, but there is another quicker way.

Hover over the bottom of the column heading letters until you see the hand icon, like this:

Freeze panes in Google Sheets 1

Click and hold down your mouse button, and then drag the thick line down:

Freeze panes in Google Sheets 2

Let go when you’ve reached the row level you want to freeze (in this case, just the top row):

Freeze panes in Google Sheets 3

This technique also works for freezing columns!

6. Quickly Create a new Google Sheet

Method 1

Create a new Google Sheet instantly by typing sheet.new in your web browser:

Create Google Sheets

It has the one drawback of creating the Sheet in your root Drive folder, so you have to manually move it to the folder you want.

Method 2

Create a new Google Sheet in the folder you’re in by using Shift + S.

If you have a specific folder open in Drive and you want to create a Sheet in that folder, just hit the shortcut Shift + S when you’re inside that folder to create a new Google Sheet there.

Create Sheets in Drive

Further Reading

Interested in more productivity tips?

Check out this article about my thoughts on how to maximize productivity at work.

5 thoughts on “6 Killer Productivity Tips for Google Sheets”

  1. Hey Ben,
    Is there a way that I could pull in comments into a master worksheet?For example when a comment occurs I can have that data go to another sheet. This is my use case (if this helps) I have multiple teams on multiple sheets and they leave comments for me. Rather than plowing through emails everyday I would rather have one master sheet which “collects” the comments from the various sheets to see there.

    1. Hi Adam,
      This would be interesting.
      Unfortunately – so far – I’ve been exploring these options and I could access notes, but not comments (by the script).

      Robert

  2. I’ve always wanted a keystroke that would allow me to switch sheets. Much like ‘alt tab’ for switching tabs on Chrome. Anything you know of on a Chromebook that allows that feature? Thanks!!!

Leave a Reply

Your email address will not be published. Required fields are marked *