Check
Search
Apps
Google Sheets
Create and edit spreadsheets.
93
Shortcuts
81
Matching
move one cell up
↑
move one cell down
↓
move one cell left / move one character to the left (when in cell edit mode)
←
move one cell right / move one character to the right (when in cell edit mode)
→
go to the leftmost cell in the current row
^
←
go to the rightmost cell in the current row
^
→
go to the bottommost cell in the current column
^
↓
go to the topmost cell in the current column
^
↑
move to the beginning of the row
↖
move to the beginning of the sheet / move to the beginning of the cell content (when in cell edit mode)
^
↖
move to the end of the row
↘
move to the cell on the right / complete the data entry and move to the cell on the right
↹
move to the cell on the left / completes the data entry and moves to the cell on the left
⇧
↹
move to the end of the sheet / move to the end of the cell content (when in cell edit mode)
^
↘
move to the next sheet
⇧
^
⇟
move to the previous sheet
⇧
^
⇞
display the list of sheets
⇧
⎇
K
copy the selected cells
^
C
cut the selected cells
^
X
paste the content of the selected cells
^
V
paste the values only
⇧
^
V
undo
^
Z
redo
^
Y
repeat the last action
F4
insert/edit notes (comments)
⇧
F2
find within the sheet
^
F
opens the find and replace dialogue box
^
H
save (every change is automatically saved in the drive)
^
S
open a file
^
O
print
^
P
show the common keyboard shortcuts
^
/
compact controls
⇧
^
F
open a hyperlink (when the cell with a link is selected) / insert a new line in the same cell
⎇
↵
enable the screen reader support
^
⎇
Z
select column
^
␣
select row
⇧
␣
select all
^
A
complete the data entry and move to the cell below
↵
completes the data entry and moves to the cell above
⇧
↵
open the edit mode
F2
fill all the selected cells
^
↵
copy the content of the selected cell in the cell below (all cells should be selected)
^
D
copy the content of the selected cell in the cell to the right (all cells should be selected)
^
R
select all the content to the left of the cursor
⇧
↑
select all content to the right of the cursor
⇧
↓
insert a new sheet
⇧
F11
insert a hyperlink
^
K
insert the current time
⇧
^
;
insert the current date
^
;
insert the row above (in Google Chrome)
I
⎇
R
insert the row above (in other browsers)
⇧
I
⎇
R
insert the row below (in Google Chrome)
I
⎇
W
insert the row below (in other browsers)
⇧
I
⎇
W
insert a column to the left (in Google Chrome)
I
⎇
C
insert a column to the left (in other browsers)
⇧
I
⎇
C
insert a column to the right (in Google Chrome)
I
⎇
G
insert a column to the right (in other browsers)
⇧
I
⎇
G
clear the cell contents Google Sheets shortcut
␡
bold the contents of the selected cell
^
B
underline the contents of the selected cell
^
U
italicize the contents of the selected cell
^
I
apply the strikethrough format
⇧
⎇
5
align the cell contents to the center
⇧
^
E
align the cell contents to the left
⇧
^
L
align the cell contents to the right
⇧
^
R
apply a top border to the selected cells
⇧
⎇
1
apply the right border to the selected cells
⇧
⎇
2
apply the bottom border to the selected cells
⇧
⎇
3
apply a left border to the selected cells
⇧
⎇
4
remove the borders from the selected cells
⇧
⎇
6
apply the outer border to the selected cells
⇧
⎇
7
apply the decimal format
⇧
^
1
apply the time format
⇧
^
2
apply the date format
⇧
^
3
apply the currency format
⇧
^
4
apply the percentage format
⇧
^
5
apply the exponential format
⇧
^
6
clear all formatting
^
\
show all formulas
^
~
wrap the current formula in an array formula
⇧
^
↵
collapse an expanded array formula
^
E
show/hide the formula help (when entering a formula)
⇧
F1
open the file menu (in Google Chrome)
⎇
F
open the edit menu (in Google Chrome)
⎇
E
open the view menu (in Google Chrome)
⎇
V
open the insert menu (in Google Chrome)
⎇
I
open the format menu (in Google Chrome)
⎇
O
open the data menu (in Google Chrome)
⎇
D
open the tools menu (in Google Chrome)
⎇
T
open the add-ons menu
⎇
N
help menu (in Google Chrome)
⎇
H
sheet menu (copy, delete, and other sheet actions)
⇧
⎇
S
context menu
⇧
^
\
Don't see your shortcut? Learn how to contribute.