101 Google Sheets Keyboard Shortcuts

Google Sheets Keyboard Shortcuts - Spreadsheets

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

Google Sheets Keyboard Shortcuts – Menu

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:

>