GOOGLE SHEETS
Shortcuts
Master Google Sheets with these essential productivity keys
마우스 오버 시 키가 강조됩니다
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
Back
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
Enter
Shift
Z
X
C
V
B
N
M
,
.
/
Shift
Cmd
Opt
Alt
Space
Alt
Fn
Cmd
Cmd+Shift+L
Create or remove filterF2
Edit active cellCmd+Enter
Finish formula entry or toggle checkboxesCmd+Opt+Shift+K / C
Insert row above / column leftCmd+Shift+V
Paste without formattingCmd+/
Show keyboard shortcuts helpCmd+\
Clear all formattingCmd+Shift+1-5
Apply quick data formats (Number, Percentage, etc.)Cmd+Opt+9 / 0
Hide row or columnCmd+K
Insert or edit linkCore Top 10
Cmd+Shift+L
Create or remove filterF2
Edit active cellCmd+Enter
Finish formula entry or toggle checkboxesCmd+Opt+Shift+K / C
Insert row above / column leftCmd+Shift+V
Paste without formattingCmd+/
Show keyboard shortcuts helpCmd+\
Clear all formattingCmd+Shift+1-5
Apply quick data formats (Number, Percentage, etc.)Cmd+Opt+9 / 0
Hide row or columnCmd+K
Insert or edit link01 — Cell Interaction
F2
Edit active cellCmd+Shift+V
Paste without formattingCmd+\
Clear formattingCmd+K
Insert linkCmd+Enter
Toggle checkbox02 — Rows & Columns
Cmd+Opt+Shift+K
Insert row aboveCmd+Alt+Shift+C
Insert column leftCmd+Opt+-
Delete rowCmd+Alt+-
Delete columnCmd+j
Select rowCmd+Shift+j
Select columnCmd+Opt+9
Hide rowCmd+Opt+0
Hide column03 — Navigation & Formatting
Cmd+Shift+L
Toggle filterCmd+Shift+1
Format as decimalCmd+Shift+2
Format as timeCmd+Shift+3
Format as dateCmd+Shift+4
Format as currencyCmd+Shift+5
Format as percentageCmd+Shift+7
Apply border04 — Formulas & Help
Cmd+Shift+Enter
Insert ArrayFormulaCmd+/
Show all keyboard shortcutsOption+Shift+I
Search the menus---