Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.
The fact that you can use it for free (as it comes with every Google account) is a huge reason for this fast adoption.
In this article, I have listed 101 Google Sheets Keyboard Shortcuts that will save you a lot of time.
Scroll down to see all the Google Sheets Keyboard Shortcuts.
Google Sheets Keyboard Shortcuts – Navigation
Move One Cell Up/Down/Left/Right. |
↑ ↓ ← → |
Go to the Left Most Cell in the Current Row. |
Ctrl ← |
Go to the Right Most Cell in the Current Row. |
Ctrl → |
Go to Bottom Most Cell in the Current Column. |
Ctrl ↓ |
Go to Top Most Cell in the Current Column. |
Ctrl ↑ |
Move to the beginning of the row. |
Home |
Move to the beginning of the sheet. |
Ctrl Home |
Move to the end of the row. |
End |
Move to the cell on the right. |
Tab |
Move to the cell on the left. |
Shift Tab |
Move to the end of the sheet. |
Ctrl End |
Move to the next sheet. |
Ctrl Shift PageDown |
Move to the previous sheet. |
Ctrl Shift PageUp |
Display the list of sheets. |
Alt Shift K |
Google Sheets Keyboard Shortcuts – Cut/Copy/Paste
Copy the Selected Cells. |
Ctrl C |
Cut the Selected Cells. |
Ctrl X |
Paste the Content of the Selected Cells. |
Ctrl V |
Paste Values Only. |
Ctrl Shift V |
Google Sheets Keyboard Shortcuts – General
Undo |
Ctrl Z |
Redo |
Ctrl Y |
Repeat the Last Action |
F4 |
Insert/Edit Note (comment) |
Shift F2 |
Find within the Sheet |
Ctrl F |
Opens Find and replace Dialogue Box |
Ctrl H |
Save (Every change is saved automatically in Drive) |
Ctrl S |
Open a File |
Ctrl O |
Ctrl P |
|
Show common keyboard shortcuts |
Ctrl / |
Compact Controls |
Ctrl Shift F |
Open Hyperlink (when the cell with a link is selected) |
Alt Enter |
Enable screen reader support |
Ctrl Alt Z |
Google Sheets Keyboard Shortcuts – Selection
Select column |
Ctrl Space |
Select row |
Shift Space |
Select all |
Ctrl A |
Google Sheets Keyboard Shortcuts – Data Entry
Complete Data Entry and Move to the Cell Below |
Enter |
Completes Data Entry and Move to the Cell Above |
Shift Enter |
Insert a New Line in the Same Cell |
Alt Enter |
Completes Data Entry & Move to the Cell on the Right |
Tab |
Completes Data Entry & Move to the Cell on the Left |
Shift Tab |
Get into Edit Mode |
F2 |
Fill all the Selected Cells |
Ctrl Enter |
Copy the content of the selected cell in the cell below (all cells should be selected) |
Ctrl D |
Copy the content of the selected cell in the cell to the right (all cells should be selected) |
Ctrl R |
Move One Character to the Left (when in cell edit mode) |
Left Arrow |
Move One Character to the Right (when in cell edit mode) |
Right Arrow |
Select all content to the left of the cursor |
Shift Up Arrow |
Select all content to the Right of the cursor |
Shift Down Arrow |
Move to the end of the cell content (when in cell edit mode) |
Ctrl End |
Move to the beginning of the cell content (when in cell edit mode) |
Ctrl Home |
Google Sheets Keyboard Shortcuts – Insert
Insert New Sheet |
Shift F11 |
Insert Hyperlink |
Ctrl K |
Insert Current Time |
Ctrl Shift ; |
Insert Current Date |
Ctrl ; |
Insert Row Above (in Google Chrome) |
Alt I R |
Insert Row Above (in Other Browsers) |
Alt Shift I R |
Insert Row Below (in Google Chrome) |
Alt I W |
Insert Row Below (in Other Browsers) |
Alt Shift I W |
Insert Column to the Left (in Google Chrome) |
Alt I C |
Insert Column to the Left (in Other Browsers) |
Alt Shift I C |
Insert Column to the Right (in Google Chrome) |
Alt I G |
Insert Column to the Right (in Other Browsers) |
Alt Shift I G |
Google Sheets Keyboard Shortcuts – Delete
Clear Cell Contents |
Delete |
Delete Current Row (in Google Chrome) |
Alt E D |
Delete Current Row (in Other Browsers) |
ALT Shift E D |
Delete Current Column (in Google Chrome) |
Alt E E |
Delete Current Column (in Other Browsers) |
ALT Shift E E |
Google Sheets Keyboard Shortcuts – Formatting
Bold the contents of the selected cell |
Ctrl B |
Underline the contents of the selected cell |
Ctrl U |
Italicize the contents of the selected cell |
Ctrl I |
Apply the Strikethrough Format |
Alt Shift 5 |
Center align the contents of the selected cell. |
Ctrl Shift E |
Left aligns the contents of the selected cell. |
Ctrl Shift L |
Right-align the contents of the selected cell. |
Ctrl Shift R |
Apply a top border to the selected cells. |
Alt Shift 1 |
Apply the right border to the selected cells. |
Alt Shift 2 |
Apply the bottom border to the selected cells. |
Alt Shift 3 |
Apply a left border to the selected cells |
Alt Shift 4 |
Remove borders from the selected cells. |
Alt Shift 6 |
Apply the outer border to the selected cells. |
Alt Shift 7 |
Apply the decimal format |
Ctrl Shift 1 |
Apply the time format. |
Ctrl Shift 2 |
Apply the date format. |
Ctrl Shift 3 |
Apply the currency format. |
Ctrl Shift 4 |
Apply the percentage format. |
Ctrl Shift 5 |
Apply the exponential format. |
Ctrl Shift 6 |
Clear All formatting. |
Ctrl \ |
Google Sheets Keyboard Shortcuts – Formula Related
Show all formulas. |
Ctrl ~ |
Wrap the current formula in an array formula. |
Ctrl Shift Enter |
Collapse an expanded array formula. |
Ctrl E |
Show/hide formula help (when entering a formula). |
Shift F1 |
Google Sheets Keyboard Shortcuts – Menu
Open File menu (in Google Chrome). |
Alt F |
Open the Edit menu (in Google Chrome). |
Alt E |
Open View menu (in Google Chrome). |
Alt V |
Open Insert menu (in Google Chrome). |
Alt I |
Open Format menu (in Google Chrome). |
Alt O |
Open Data menu (in Google Chrome). |
Alt D |
Open the Tools menu (in Google Chrome). |
Alt T |
Open the Add-ons menu. |
Alt N |
Help menu (in Google Chrome). |
Alt H |
Sheet menu (copy, delete, and other sheet actions). |
Alt Shift S |
Context menu. |
Ctrl Shift \ |
Useful Google Sheets Tutorials:
- 10 Google Sheets Tips that’ll Help You Get Work Done Faster.
- VLOOKUP Function in Google Sheets.
- Query Function in Google Sheets.
- Creating a Drop Down List in Google Sheets.
- How to Print Labels from Google Sheets
Other Useful Resources: