Google Sheets
General
|
⌃
␣
|
Select column |
|
⇧
␣
|
Select row |
|
⌘
A
|
Select all |
|
⌘
⇧
⌫
|
Hide background over selected cells |
|
⌘
Z
|
Undo |
|
⌘
Y
|
Redo |
|
⌘
F
|
find |
|
⌘
⇧
H
|
Find and replace |
|
⌘
↩
|
Fill range |
|
⌘
D
|
Fill down |
|
⌘
R
|
Fill right |
|
⌘
S
|
Save |
|
⌘
O
|
Open |
|
⌘
P
|
|
|
⌘
C
|
Copy |
|
⌘
X
|
Cut |
|
⌘
V
|
Paste |
|
⌘
⇧
V
|
Paste values only |
|
⌘
/
|
Show common keyboard shortcuts |
|
⌃
⇧
K
|
Compact controls |
|
⌘
⇧
K
|
Input tools on/off |
|
⌘
⌥
⇧
K
|
Select input tools |
Cell Formatting
|
⌘
B
|
Bolds |
|
⌘
U
|
Underline |
|
⌘
I
|
Italicize |
|
⌥
⇧
5
|
Strikethrough |
|
⌘
⇧
E
|
Center align |
|
⌘
⇧
L
|
Left align |
|
⌘
⇧
R
|
Right align |
|
⌥
⇧
1
|
Apply top border |
|
⌥
⇧
2
|
Apply right border |
|
⌥
⇧
3
|
Apply bottom border |
|
⌥
⇧
4
|
Apply left border |
|
⌥
⇧
6
|
Remove borders |
|
⌥
⇧
7
|
Apply outer border |
|
⌘
K
|
Insert link |
|
⌘
⇧
;
|
Insert name |
|
⌘
;
|
Insert date |
|
⌃
⇧
1
|
Format as decimal |
|
⌃
⇧
2
|
Format as time |
|
⌃
⇧
3
|
Format as date |
|
⌃
⇧
4
|
Format as currency |
|
⌃
⇧
5
|
Format as percentage |
|
⌃
⇧
6
|
Format as exponent |
|
⌘
\\
|
Clear formatting |
Insert or Delete Rows or Columns
|
⌃
⌥
I
then
R
|
Insert row above |
|
⌃
⌥
I
then
W
|
Insert row below |
|
⌃
⌥
I
then
C
|
Insert column to the left |
|
⌃
⌥
I
then
G
|
Insert column to the right |
|
⌃
⌥
E
then
D
|
Delete row |
|
⌃
⌥
E
then
E
|
Delete column |
Spreadsheet Navigation
|
Fn
←
|
Move to beginning of row |
|
⌘
Fn
←
|
Move to beginning of sheet |
|
Fn
→
|
Move to end of row |
|
⌘
Fn
→
|
Move to end of sheet |
|
⌘
⌫
|
Scroll to active cell |
|
⌘
⇧
Fn
↓
|
Move to next sheet |
|
⌘
⇧
Fn
↑
|
Move to previous sheet |
|
⌥
⇧
K
|
Display list of sheets |
|
⌥
↩
|
Open hyperlink |
|
⌃
⌘
⇧
M
|
Move focus out of spreadsheet |
|
⌥
⇧
Q
|
Move to quicksum |
|
hold
⌃
⌘
press
E
then
P
|
Move focus to popup |
|
⌃
⌘
R
|
Open drop-down menu on filtered cell |
|
⌘
⌥
⇧
G
|
Open revision history |
|
⇧
⎋
|
Open chat inside the spreadsheet |
|
⌘
⎋
|
Close drawing editor |
Notes and Comments
|
⇧
F2
|
Insert/edit note |
|
⌘
⌥
M
|
Insert/edit comment |
|
⌘
⌥
⇧
A
|
Open comment discussion thread |
|
hold
⌃
⌘
press
E
then
C
|
Enter current comment |
|
hold
⌃
⌘
press
N
then
C
|
Move to next comment |
|
hold
⌃
⌘
press
P
then
C
|
Move to previous comment |
Menus
|
⌃
⌥
F
|
File menu |
|
⌃
⌥
E
|
Edit menu |
|
⌃
⌥
V
|
View menu |
|
⌃
⌥
I
|
Insert menu |
|
⌃
⌥
O
|
Format menu |
|
⌃
⌥
D
|
Data menu |
|
⌃
⌥
T
|
Tools menu |
|
⌃
⌥
M
|
Form menu |
|
⌃
⌥
N
|
Add-ons menu |
|
⌃
⌥
H
|
Help menu |
|
⌃
⌥
A
|
Accessibility menu |
|
⌥
⇧
S
|
Sheet menu |
|
⌘
⇧
\\
|
Context menu |
Formulas
|
⌃
~
|
Show all formulas |
|
⌘
⇧
↩
|
Insert array formulas |
|
⌘
E
|
Collapse an expanded array formula |
|
⇧
Fn
F1
|
Show/hide formula help |