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 of 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 beginning of the row. |
Home
|
| Move to beginning of the sheet. |
Ctrl
Home
|
| Move to end of the row. |
End
|
| Move to the cell on the right. |
Tab
|
| Move to the cell on the left. |
Shift
Tab
|
| Move to 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 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
|
| Print |
Ctrl
P
|
| Show common keyboard shortcuts |
Ctrl
/
|
| Compact Controls |
Ctrl
Shift
F
|
| Open Hyperlink (when the cell with 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 Ttime |
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 align the contents of the selected cell. |
Ctrl
Shift
L
|
| Right align the contents of the selected cell. |
Ctrl
Shift
R
|
| Apply top border to the selected cells. |
Alt
Shift
1
|
| Apply right border to the selected cells. |
Alt
Shift
2
|
| Apply bottom border to the selected cells. |
Alt
Shift
3
|
| Apply left border to the selected cells |
Alt
Shift
4
|
| Remove borders from the selected cells. |
Alt
Shift
6
|
| Apply 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
|
| Open File menu (in Google Chrome). |
Alt
F
|
| Open 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 Tools menu (in Google Chrome). |
Alt
T
|
| Open 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:
Other Useful Resources:
