There are so many things that a lot of us do regularly in Google Sheets. And while a lot of these options are readily available with a few clicks, you can be a lot more productive if you get used to a few Google Sheets keyboard shortcuts.
You’ll be amazed at how much faster you can work when you know only a couple of shortcuts (mostly for the tasks that you do a lot – such as formatting cells or deleting rows).
In this article, I am sharing my top 20 Google Sheets keyboard shortcuts that I find myself using quite often (and I am sure these will also save you time).
In case you want a quick list, click here to get to the table at the end of this article that shows all Google Sheets keyboard shortcuts in one place.
So let’s get started!
Enabling Compatible Shortcuts in Google Sheets
Before I take you to the shortcuts, there is something you need to do to make sure you have access to all these shortcuts.
Since Google Sheets is a web-based tool, a lot of the keyboard shortcuts that are available in other spreadsheet tools such as MS Excel are not available and you need to enable these.
Below are the steps to enable compatible shortcuts in Google Sheets:
- Click the Help option in the menu
- Click on Keyboard shortcuts
- In the Keyboard Shortcuts dialog box that opens, enable the ‘Enable compatible spreadsheet shortcuts‘ option
Once you do this, you will get access to a lot of shortcuts that are also the same in Excel.
Top 20 Google Sheets Shortcuts
Here is a list of my top 20 Google Sheets keyboard shortcuts.
In case you want to get the whole list, I have a bigger list at the end of this article (click here to jump to the bigger list).
1. Repeat the Last Action
If you can only pick up one Google Sheets shortcut from this article, it should be this one.
Below is the Google Sheets keyboard shortcut to repeat the last action:
PC | Mac | |
Repeat the Last Action | F4 |
With this shortcut, you will be able to repeat the last action you performed again with a single button.
For example, if you color a cell red, you can go to any other cell and simply press F4 and it will color this cell red as well.
Just remember that it will only repeat the last action. So if you make the cell color red make the font style bold, using F4 will only apply bold font format as that was the last action it remembers.
2. Cut/Copy/Paste/Undo/Redo
These are the staple shortcuts that are standard and work across applications (Google applications as well as outside Google such as Excel and PowerPoint).
Below are the shortcuts to Cut/Copy/Paste/Undo/Redo:
In PC | In Mac | |
Cut | Control + X | Command + X |
Copy | Control + C | Command +C |
Paste | Control + V | Command + V |
Undo | Control + Z | Command + Z |
Redo | Control + Y | Command + Y |
3. Insert Row or Insert Column
Inserting a new row or column is again something we need to do quite often.
Below is the keyboard shortcut to quickly insert a row (or insert a column) in Google Sheets:
In PC | In Mac | |
Insert Row Above | ALT + I + R | Ctrl + Option + I, then R |
Insert Row Below | ALT + I + W | Ctrl + Option + I, then W |
Insert Column above | ALT + I + C | Ctrl + Option + I, then C |
Insert Column below | ALT + I + G | Ctrl + Option + I, then G |
In case you’re not using Chrome on PC, you need to hold the Shift key with the ALT key when using these shortcuts.
Related tutorial: How to Insert Multiple Rows in Google Sheets
4. Delete Row or Delete Column
Just like way we inserted rows and columns, you can also easily delete rows and columns using a keyboard shortcut.
Below is the keyboard shortcut to quickly delete a row in Google Sheets:
In PC | In Mac | |
Delete Current Row | ALT + E + D | Ctrl + Option + E, then D |
Delete Current Column | ALT + E + E | Ctrl + Option + E, then E |
In case you’re not using Chrome on PC, you need to hold the Shift key with the ALT key when using these shortcuts.
Related tutorials: How to Delete Empty Rows in Google Sheets
5. Select the Whole Row (or Select Whole Column)
This could be useful when you want to apply or remove the formatting from the entire row or column at one go.
Below are the shortcuts to select the whole row or column in one go in Google Sheets:
In PC | In Mac | |
Select Whole Row | Shift + Spacebar | Shift + Spacebar |
Select Whole Column | Control + Spacebar | Control + Spacebar |
6. Paste Value Only (or Paste format only)
When you copy and paste cells in Google Sheets, it will copy the value in the cell as well as the formula and the formatting of the cell (including the conditional formatting).
With this shortcut, you can copy the cell and only paste the value in some other cell. This is also useful when you want to convert formula to values.
You can copy the cells that have the formulas and simply paste them as value over them. This will make the formulas go away and you will be left with only the values and the formatting that was originally there.
Similarly, you can also just copy the format of cells and nothing else.
Below are the shortcuts to paste only values or paste only formats (use these after you have copied the cells and selected the ones where you need to paste these):
In PC | In Mac | |
Paste Values Only | Control + Shift + V | Command + Shift + V |
Paste Format Only | Control + ALT + V | Command + ALT + V |
7. Find Values (Or Find and Replace Values) in Google Sheets
You can easily find (or find and then replace) content of cells based on their values.
And to do this, you first need to open the find and replace dialog box.
Below are the keyboard shortcuts to open the Find (or Find and Replace) dialog box in Google Sheets:
In PC | In Mac | |
Find Values | Control + F | Command + F |
Find and Replace | Control + H | Command + Shift + F |
Note that when you open the Find dialog box, it just opens a simple search box at the top right of the sheet. And when you enter any text in it, Google Sheets would highlight all the cells that have the matching value (in real-time) and also show you the number of cells where it found the value.
When you use the Find and Replace option, it opens a dialog box that has a lot many options to find and replace text in Google Sheets.
Related Tutorial: How To Remove Duplicates In Google Sheets
8. Add New Sheet in Google Sheets with a Shortcut
While it’s already quite easy to add a new sheet to your Google Sheets document, this shortcut makes it really easy and fast.
Below is the keyboard shortcut to add a new sheet in the current Google Sheets document:
In PC | In Mac | |
Add new sheet | Shift + F11 | Not available on Mac |
Unfortunately, this shortcut is not available for Mac (at least at the time of writing this tutorial)
9. Formatting Shortcuts (Bold, Underline, Italics, Strikethrough)
There are a bunch of formatting shortcuts that can save you time and make it a good experience working with Google Sheets.
And thankfully, these are the standard keyboard shortcuts that you may already know if you have been using computers for a while.
Below are the commonly used formatting keyboard shortcuts:
In PC | In Mac | |
Apply Bold formatting | Control + B | Command + B |
Apply Underline formatting | Control + U | Command + U |
Apply Italic formatting | Control + I | Command + I |
Apply Strikethrough formatting | Alt + Shift + 5 | Option + Shift + 5 |
While the first three are quite standard, the shortcut to apply strikethrough in Google Sheets is specific to Google Sheets (in Excel you need to use Control + 5 to apply strikethrough formatting).
Also, note that these are toggle shortcuts. This means that if you use it once, it will apply the formatting and if you use it again, it will remove the formatting.
10. Cell Alignment (Center, Left, Right) Shortcuts in Google Sheets
Alignment options are again something used quite often, and Google Sheets has made it quite easy to change the alignment by adding these options in the toolbar.
But in case you prefer shortcuts to change the alignment (center, right, left), here are the shortcuts:
In PC | In Mac | |
Center Align | Ctrl + Shift + E | Command + Shift + E |
Left Align | Ctrl + Shift + L | Command + Shift + L |
Right Align | Ctrl + Shift + R | Command + Shift + R |
11. Insert a Link in a Cell Using a Shortcut
You can link your cells with external URLs as well as to any sheet or cell/range in the current Google Sheets document.
And to do this, you need to open the ‘Insert link’ dialog box. Once you have it open, there are many options to create the link.
Below is the keyboard shortcut to insert a link by opening the Insert Link dialog box:
In PC | In Mac | |
Insert Link | Control + K | Command + K |
Related tutorial: How to Create Table of Contents in Google Sheets | Remove Hyperlinks in Google Sheets
12. Insert Date and Time Shortcuts In Google Sheets
If you want to quickly get the current date or the current time value in a cell, you can do that easily with a keyboard shortcut.
Below is the shortcut to insert the current date or current time in Google sheets:
In PC | In Mac | |
Insert Current Time | Ctrl + Shift + ; | Command + Shift + ; |
Insert Current Date | Ctrl + ; | Command + ; |
Note that when you use this formula, it will insert a static value in the cell which will not change as time passes.
If you want to get a value that updates to reflect the current date or time, you can use the TODAY and NOW functions.
Related Tutorial: Automatically Insert Timestamps in Google Sheets
13. Clear all formatting from a cell or range of cells
If you want to quickly remove all the formatting from a cell or a range of cells, you can use this keyboard shortcut.
It will remove everything (such as the color, border, font size, font color) except the value in the cell. Once you use it, you will have the cell in the default state with the cell content in it.
Below is the keyboard shortcut to remove all formatting from a cell in Google Sheets:
In PC | In Mac | |
Clear all formatting | Ctrl + \ | Command + \ |
Related tutorial: Apply Conditional Formatting based on Another Cell Value in Google Sheets
14. Move to the Next Sheet (or Previous Sheets) with a Keyboard Shortcut
As you get multiple sheets in a Google Sheets document, it can be a pain going back and forth these sheets.
Thankfully there is a keyboard shortcut that allows you to quickly go to the next worksheet (or go to the previous worksheet)
In PC | In Mac | |
Move to the Next sheet | Ctrl + Shift + Page Down | Command + Shift + Fn + Down arrow |
Move to the previous sheet | Ctrl + Shift + Page Up | Command + Shift + Fn + Up arrow |
Using these shortcuts would only take you to the next sheet (or previous sheet if you use the second one). If you need to go to the sheets which are next to next, you will have to use the keyboard shortcut twice.
15. Display All Sheets in the Google Sheets Workbook
Another useful feature when working with a lot of sheets is to quickly see a list of all the sheets in one place and then select the one to which you want to go.
When you have a lot of sheets, this is a better method than moving through sheets using the shortcuts covered in the above section.
In PC | In Mac | |
Display all sheets | Alt + Shift + K | Option + Shift + K |
The above shortcut will only show you a list of all the sheets in the workbook. You will have to go to the one-sheet name that you want to go to and then click on it.
Also, you will see hidden sheets in the list, and if you click on it, you will be taken to that sheet and it will be unhidden.
16. Open links with a shortcut
When you have a lot of links in cells and you want to open all these at one go, you can use this keyboard shortcut.
In PC | In Mac | |
Open Hyperlink | ALT + Enter | Option + Enter |
I find it useful when I have multiple URLs in cells that I want to open all at one go instead of opening it one by one.
17. Insert Note/Comment with Keyboard Shortcut
In Google Sheets, you can insert a note in a cell or a comment (which is a threaded conversation) using the below keyboard shortcuts.
In PC | In Mac | |
Insert Note | Shift + F2 | Shift + F2 |
Insert /Edit comment | Control + ALT + M | Command + Option + M |
18. Show All formulas in the worksheet
When you enter a formula in a cell in Google Sheets, it would always show you the result of the formula.
But if you want to quickly see all the formulas (and not their values), you can use the below keyboard shortcut.
In PC | In Mac | |
Show All Formulas | Control ~ | Control ~ |
This is a toggle keyboard shortcut, which means that if you use it again, it will revert the cells with formulas back to the original state where they will show values and not formulas.
19. Change references to Absolute/Relative/Mixed
When working with formulas in Google Sheets, you may want to change the reference to absolute or relative.
While you can do this by manually adding the dollar sign before the column alphabet or row number, it’s better to use the below keyboard shortcut:
In PC | In Mac | |
Absolute/Relative references | F4 | Fn + F4 |
20. Fill Down (or Fill Right) the Value or formula
When doing data entry work in Google Sheets, you will often find yourself copying and pasting the same cell value that you have in the cell above (or in the cell to the right).
Instead of doing it the long way by first copying the cell and then pasting it, you can use the below shortcuts:
In PC | In Mac | |
Fill Down | Control + D | Command + D |
Fill Right | Control + R | Command + R |
When you use this shortcut, it will copy the value in the cell as well as the formatting/formula in it.
So there are my top 20 Keyboard shortcuts in Google Sheets that I use on a daily basis.
There are, however, a lot more of these and I am providing a bigger list of these shortcuts below.
100+ Google Sheets Keyboard Shortcuts
Commonly Used Shortcuts in Google Sheets | ||
in PC | in Mac | |
Select column | Ctrl + Space | Ctrl + Space |
Select row | Shift + Space | Shift + Space |
Select all | Ctrl + a | ⌘ + a |
Undo | Ctrl + z | ⌘ + z |
Redo | Ctrl + y | ⌘ + y |
Find | Ctrl + f | ⌘ + f |
Find and replace | Ctrl + h | ⌘ + Shift + h |
Fill range | Ctrl + Enter | ⌘ + Enter |
Fill down | Ctrl + d | ⌘ + d |
Fill right | Ctrl + r | ⌘ + r |
Save | Ctrl + s | ⌘ + s |
Open | Ctrl + o | ⌘ + o |
Ctrl + p | ⌘ + p | |
Copy | Ctrl + c | ⌘ + c |
Cut | Ctrl + x | ⌘ + x |
Paste | Ctrl + v | ⌘ + v |
Paste values only | Ctrl + Shift + v | ⌘ + Shift + v |
Show common keyboard shortcuts | Ctrl + / | ⌘ + / |
Insert new sheet | Shift + F11 | Shift + Fn + F11 |
Compact controls | Ctrl + Shift + f | Ctrl + Shift + f |
Input tools on/off | Ctrl + Shift + k | ⌘ + Shift + k |
Select input tools | Ctrl + Alt + Shift + k | ⌘ + Option + Shift + k |
Search the menus | Alt + / | Option + / |
Formatting Related | ||
PC | Mac | |
Bold | Ctrl + b | ⌘ + b |
Underline | Ctrl + u | ⌘ + u |
Italic | Ctrl + i | ⌘ + i |
Strikethrough | Alt + Shift + 5 | Option + Shift + 5 |
Center align | Ctrl + Shift + e | ⌘ + Shift + e |
Left align | Ctrl + Shift + l | ⌘ + Shift + l |
Right align | Ctrl + Shift + r | ⌘ + Shift + r |
Apply top border | Alt + Shift + 1 | Option + Shift + 1 |
Apply right border | Alt + Shift + 2 | Option + Shift + 2 |
Apply bottom border | Alt + Shift + 3 | Option + Shift + 3 |
Apply left border | Alt + Shift + 4 | Option + Shift + 4 |
Remove borders | Alt + Shift + 6 | Option + Shift + 6 |
Apply outer border | Alt + Shift + 7 | Option + Shift + 7 |
Insert link | Ctrl + k | ⌘ + k |
Insert time | Ctrl + Shift + ; | ⌘ + Shift + ; |
Insert date | Ctrl + ; | ⌘ + ; |
Insert date and time | Ctrl + Alt + Shift + ; | ⌘ + Option + Shift + ; |
Format as decimal | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
Format as time | Ctrl + Shift + 2 | Ctrl + Shift + 2 |
Format as date | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
Format as currency | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
Format as percentage | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
Format as exponent | Ctrl + Shift + 6 | Ctrl + Shift + 6 |
Clear formatting | Ctrl + \ | ⌘ + \ |
Formula related keyboard shortcuts | ||
PC | Mac | |
Show all formulas | Ctrl + ~ | Ctrl + ~ |
Insert array formula | Ctrl + Shift + Enter | ⌘ + Shift + Enter |
Collapse an expanded array formula | Ctrl + e | ⌘ + e |
Show/hide formula help | Shift + F1 | Shift + Fn + F1 |
Full/compact formula help | F1 | Fn + F1 |
Absolute/relative references | F4 | Fn + F4 |
Toggle formula result previews | F9 | Fn + F9 |
Resize formula bar | Ctrl + Up / Ctrl + Down | Ctrl + Option + Up and Ctrl + Option + Down |
Navigate in Google Sheets | ||
PC | Mac | |
Move to the beginning of row | Home | Fn + Left Arrow |
Move to the beginning of the sheet | Ctrl + Home | ⌘ + Fn + Left Arrow |
Move to end of the row | End | Fn + Right Arrow |
Move to end of the sheet | Ctrl + End | ⌘ + Fn + Right Arrow |
Scroll to the active cell | Ctrl + Backspace | ⌘ + Backspace |
Move to next sheet | Alt + Down Arrow | Option + Down Arrow |
Move to the previous sheet | Alt + Up Arrow | Option + Up Arrow |
Display list of sheets | Alt + Shift + k | Option + Shift + k |
Open hyperlink | Alt + Enter | Option + Enter |
Open Explore | Alt + Shift + x | Option + Shift + x |
Go to the side panel | Ctrl + Alt + . | ⌘ + Option + . |
Move focus out of spreadsheet | Ctrl + Alt + Shift + m | Ctrl + ⌘ + Shift + m |
Move to quicksum | Alt + Shift + q | Option + Shift + q |
Move focus to popup | holding Ctrl + Alt, press e then p | holding Ctrl + ⌘, press e then p |
Open drop-down menu on filtered cell | Ctrl + Alt + r | Ctrl + ⌘ + r |
Open revision history | Ctrl + Alt + Shift + h | ⌘ + Option + Shift + h |
Open chat inside the spreadsheet | Shift + Esc | Shift + Esc |
Close drawing editor | Shift + Esc | ⌘ + Esc |
Edit notes and comments | ||
PC | Mac | |
Insert/edit note | Shift + F2 | Shift + F2 |
Insert/edit a comment | Ctrl + Alt + m | ⌘ + Option + m |
Open comment discussion thread | Ctrl + Alt + Shift + a | ⌘ + Option + Shift + a |
Enter current comment | holding Ctrl + Alt, press e then c | holding Ctrl + ⌘, press e then c |
Move to next comment | holding Ctrl + Alt, press n then c | holding Ctrl + ⌘, press n then c |
Move to the previous comment | holding Ctrl + Alt, press p then c | holding Ctrl + ⌘, press p then c |
Open a menu (When not using Chrome on a PC, also hold the Shift key with the ALT key) | ||
PC | Mac | |
File menu | in Google Chrome: Alt + f | Ctrl + Option + f |
Edit menu | in Google Chrome: Alt + e | Ctrl + Option + e |
View menu | in Google Chrome: Alt + v | Ctrl + Option + v |
Insert menu | in Google Chrome: Alt + i | Ctrl + Option + i |
Format menu | in Google Chrome: Alt + o | Ctrl + Option + o |
Data menu | in Google Chrome: Alt + d | Ctrl + Option + d |
Tools menu | in Google Chrome: Alt + t | Ctrl + Option + t |
Open insert menu | Ctrl + Alt + Shift + = | ⌘ + Option + = (with cells selected) |
Form menu | in Google Chrome: Alt + m | Ctrl + Option + m |
Add-ons menu | in Google Chrome: Alt + n | Ctrl + Option + n |
Help menu | in Google Chrome: Alt + h | Ctrl + Option + h |
Accessibility menu | in Google Chrome: Alt + a | Ctrl + Option + a |
Sheet menu | Alt + Shift + s | Option + Shift + s |
Context menu | Ctrl + Shift + \ | ⌘ + Shift + \ |
Add or change rows and columns | ||
PC | Mac | |
Insert rows above | Alt + i, then r | Ctrl + Option + i, then r |
Insert rows below | Alt + i, then w | Ctrl + Option + i, then b |
Insert columns to the left | Alt + i, then c | Ctrl + Option + i, then c |
Insert columns to the right | Alt + i, then o | Ctrl + Option + i, then o |
Delete rows | Ctrl + Alt + – (with rows selected) | ⌘ + Option + – |
Delete columns | Ctrl + Alt + – (with columns selected) | ⌘ + Option + – |
Hide row | Ctrl + Alt + 9 | ⌘ + Option + 9 |
Unhide row | Ctrl + Shift + 9 | ⌘ + Shift + 9 |
Hide column | Ctrl + Alt + 0 | ⌘ + Option + 0 |
Unhide column | Ctrl + Shift + 0 | ⌘ + Shift + 0 |
Group rows or columns | Alt + Shift + Right Arrow | Option + Shift + Right Arrow |
Ungroup rows or columns | Alt + Shift + Left Arrow | Option + Shift + Left Arrow |
Expand grouped rows or columns | Alt + Shift + Down Arrow | Option + Shift + Down Arrow |
Collapse grouped rows or columns | Alt + Shift + Up Arrow | Option + Shift + Up Arrow |
Help for screen readers | ||
PC | Mac | |
Turn on screen reader support | Ctrl + Alt + z | ⌘ + Option + z |
Read column | Ctrl + Alt + Shift + c | ⌘ + Option + Shift + c |
Read row | Ctrl + Alt + Shift + r | ⌘ + Option + Shift + r |
Hope you found this tutorial useful.
Other useful Google Sheets tutorials:
6 thoughts on “20 Google Sheets Shortcuts You Must Know! ⌨️”
Nice article!
Many the keyboard shortcuts I do not know before, today I found out through your post. Thank you very much to the writer for writing an informative article. This article is helped me to find the shortcut uses of the keyboard and save my time.
Maybe updated Google Sheets to be Ctrl + Option + E, D + D
I was unable to get the shortcut to delete current column, ALT + E + E, to work like the one to delete current row, ALT + E + D, but the CTRL + ALT + – did when I had the entire column selected. I didn’t see anything in the help to say what the shortcut is for delete current column and I tried some other key combinations with no luck
I forgot to mention that the ALT + E + E performs the same action as CTRL + H by displaying the Find and Replace
I can only get “12. Insert Date and Time Shortcuts” to work on English keyboards (UK/US), it doesn’t now work on Swedish keyboards.
Hej Isac, unfortunately we don’t have a Swedish member on our team to find a solution, but hopefully one of our other vistors can help.