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.