EXCEL
Shortcuts
Essential keyboard shortcuts to boost your spreadsheet productivity by 200%
마우스 오버 시 키가 강조됩니다
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
F4
Cycle Absolute/Relative ReferenceAlt+=
AutoSum (SUM)Ctrl+Shift+L
Apply/Remove FilterCtrl+1
Open Format Cells DialogCtrl+Shift+1-5
Change Data Format (Number, Date, etc.)Ctrl+T
Create TableCtrl+D
Fill DownF5
Go To Cell/Range/Special⌥+Enter
Line Break within CellCtrl+Shift+Arrows
Select to edge of dataCore Top 10
F4
Cycle Absolute/Relative ReferenceAlt+=
AutoSum (SUM)Ctrl+Shift+L
Apply/Remove FilterCtrl+1
Open Format Cells DialogCtrl+Shift+1-5
Change Data Format (Number, Date, etc.)Ctrl+T
Create TableCtrl+D
Fill DownF5
Go To Cell/Range/Special⌥+Enter
Line Break within CellCtrl+Shift+Arrows
Select to edge of data01 — Basics
⌘+C
Copy⌘+V
Paste⌘+X
Cut⌘+Z
Undo⌘+Y
Redo⌘+S
Save⌘+A
Select All⌘+P
Print02 — Navigation
Ctrl+Home
Go to cell A1Ctrl+End
Go to last used cellCtrl+→
Move to edge of data (Right)Ctrl+←
Move to edge of data (Left)Ctrl+↓
Move to edge of data (Down)Ctrl+↑
Move to edge of data (Up)Ctrl+Page Up
Previous sheetCtrl+Page Down
Next sheet03 — Selection
Shift+→
Extend selection (Right)Ctrl+Shift+End
Select to last used cellCtrl+Space
Select entire columnShift+Space
Select entire rowCtrl+Shift+L
Apply/Remove Filter04 — Formulas
=
Start formulaF4
Cycle absolute/relative referencesCtrl+`
Show/Hide formulasAlt+=
AutoSum (SUM)Ctrl+Shift+Enter
Enter array formulaF9
Calculate selected portion of formula05 — Editing
F2
Edit active cellEnter
Complete entry and move downTab
Complete entry and move rightDelete
Clear cell contentsCtrl+D
Fill down (copy from cell above)Ctrl+R
Fill right (copy from cell left)Ctrl+Enter
Fill same entry in all selected cells06 — Formatting
Ctrl+B
BoldCtrl+I
ItalicCtrl+U
UnderlineCtrl+1
Open Format Cells dialogCtrl+Shift+!
Number format (comma separated)Ctrl+Shift+$
Currency formatCtrl+Shift+%
Percentage formatCtrl+Shift+&
Apply border07 — Rows and Columns
Ctrl++
Insert Row/ColumnCtrl+-
Delete Row/ColumnCtrl+9
Hide RowCtrl+0
Hide ColumnCtrl+Shift+9
Unhide RowCtrl+Shift+0
Unhide Column08 — Others
F5
Go To dialogCtrl+F
FindCtrl+H
Find and ReplaceF11
Create ChartAlt+F1
Insert Chart from dataCtrl+N
New WorkbookCtrl+W
Close Workbook