8 Google Sheets Shortcuts You Need To Know

We already covered a list of keyboard shortcuts to help you zip through Microsoft Excel like a pro. Now we’re sharing some Google Sheets shortcuts, too. Because while Excel and Google Sheets share many similarities, the shortcuts don’t always translate.

1. Insert or Edit a Comment

Use the following shortcuts to add comments to any cell.

On a Mac:

  • + OPTION + M: Go to the cell you want to add the comment. Hold down the ⌘, OPTION, and M keys and start typing when you see the comment box pop up.

On a PC:

  • CTRL + ALT + M: Go to the cell you want to add the comment. Hold down the CTRL, ALT, and M keys and start typing when you see the comment box pop up.

Other helpful tips:

  • Use the @ symbol to tag and notify a team member in the comment. Check out a use-case scenario in our guide for creating the optimal month-end close checklist.
  • After you enter the comment, use the TAB and ENTER keys to save the comment.
  • You can navigate back to the cell and use these shortcuts to add additional comments.

2. Display All Tabs

If your Google Sheets has multiple tabs, it can be a hassle to find the one you need.

Here’s a manual way to help with that: On the bottom left corner, click on the hamburger menu icon (the three lines stacked on top of each other) to see a list of all tabs in that spreadsheet. Then click on the tab name to navigate directly to that tab.

If you’re looking for a shortcut, check out these options.

On a Mac:

  • OPTION + SHIFT + K: Hold down the OPTION, SHIFT, and K keys to display a list of all the tab names in your spreadsheet. Use the up and down arrows to navigate to the tab you need. Click ENTER to go to that tab.

On a PC:

  • ALT + SHIFT + K: Hold down the ALT, SHIFT, and K keys to display a list of all the tab names in your spreadsheet. Use the up and down arrows to navigate to the tab you need. Click ENTER to go to that tab.

3. Move to Next (or Previous) Tab

If your Google Sheets has multiple tabs, it can be a hassle to find the one you need. Use these keyboard shortcuts to navigate your spreadsheet quicker.

On a Mac:

  • OPTION + (up arrow): To move one sheet to the left, hold down the OPTION key and press the up arrow.
  • OPTION + (down arrow): To move one sheet to the right, hold down the OPTION key and press the down arrow.

On a PC:

  • ALT + (up arrow): To move one sheet to the left, hold down the ALT key and press the up arrow.
  • ALT + (down arrow): To move one sheet to the right, hold down the ALT key and press the down arrow.

4. Paste Values Only

You probably already know the common shortcuts to copy and paste. If you need a refresher:

  • On a Mac, use ⌘ + C to copy and ⌘ + V to paste.
  • On a PC, use CTRL + C to copy and CTRL + V to paste.

But sometimes you need to paste values only, which allows you to paste only the values of the copied cells (without the formatting of the copied cells).

On a Mac:

  • + SHIFT + V: Go to the cell you want to paste values in and press the ⌘, SHIFT, and V keys.

On a PC:

  • CTRL + SHIFT + V: Go to the cell you want to paste values in and press the CTRL, SHIFT, and V keys.

5. Show Formulas

Instead of navigating to each cell and looking at the formula in the formula bar, you can display formulas in the cells themselves. This shortcut is the same on a Mac and a PC.

On a Mac and a PC:

  • CONTROL + ~ (tilde key): Use the CONTROL and ~ (tilde) keys to display formulas in the cells. Use the same shortcut to revert back to the cells’ original values.

6. Remove and Add Borders

Use the following shortcuts if you need to add or remove borders around the entire cell (or group of cells).

On a Mac:

  • OPTION + SHIFT + 6: Go to the cell (or cells) with a border you want to remove. Press the OPTION, SHIFT, and 6 keys.
  • OPTION + SHIFT + 7: Go to the cell (or cells) where you want to add a border. Press the OPTION, SHIFT, and 7 keys.

On a PC:

  • ALT + SHIFT + 6: Go to the cell (or cells) with a border you want to remove. Press the ALT, SHIFT, and 6 keys.
  • ALT + SHIFT + 7: Go to the cell (or cells) where you want to add a border. Press the ALT, SHIFT, and 7 keys.

Another helpful tip: You can use this shortcut with other number keys to add border lines to different parts of the cell(s).

  • The 1 key (OPTION + SHIFT + 1 on a Mac or ALT + SHIFT + 1 on a PC) applies only the top border.
  • The 2 key applies only the right border.
  • The 3 key applies only the bottom border.
  • The 4 key applies only the left border.

7. Select Rows or Columns

Here’s an easy way to select rows and columns in Google Sheets. This shortcut is the same on a Mac and a PC.

On a Mac and a PC:

  • SHIFT + SPACEBAR: Go to any cell in the row you want to select, then hold down the SHIFT key and press the spacebar.
    • Use this shortcut one time to select only the cells in the row that have values.
    • Use this shortcut a second time to select the entire row.
    • If you want to select multiple rows, hold down the SHIFT key and use the up or down arrows to select the row(s) above or below it.
  • CTRL + SPACEBAR: Go to any cell in the row you want to select, then hold down the CTRL key and press the spacebar.
    • Use this shortcut one time to select only the cells in the column that have values.
    • Use this shortcut a second time to select the entire column.
    • If you want to select multiple columns, hold down the SHIFT key and use the up or down arrows to select the row(s) above or below it.

8. Insert and Delete Rows

Now that you’ve learned the shortcuts to select rows, use the following to insert or delete the rows you just selected.

On a Mac:

  • CTRL + OPTION + I + R: Select a row and press the CTRL, OPTION, and I keys, then the R key. Use either of the following shortcuts to insert the row above or below the selection:
    • Press ENTER to insert a row above the selection
    • Press the down arrow, then ENTER to insert a row below the selection

On a PC:

  • ALT + I + R: Select a row and press the ALT and I keys, then the R key. Use either of the following shortcuts to insert the row above or below the selection:
    • Press ENTER to insert a row above the selection
    • Press the down arrow, then ENTER to insert a row below the selection
    • Note that if you’re not using Chrome, you may need to use the ALT + SHIFT + I + R shortcut instead.

Did We Miss Any Google Sheets Shortcuts?

We know there are more Google Sheets shortcuts out there. Share your favorite ones in the comments below.

Leave a Comment