Microsoft Excel Shortcut

Daftar shortcut excel atau pintasan keyboard beserta fungsinya untuk mempermudah dan mempercepat aktifitas anda dalam menggunakan microsoft excel.
Daftar Isi | Excel Dasar | Fungsi Excel | Rumus Excel
Filter shortcuts:
Microsoft Excel Shortcut



File

Create new workbook
Ctrl
N
N
Open workbook
Ctrl
O
O
Save workbook
Ctrl
S
S
Save as
F12
S
Open print options window
Ctrl
P
P
Close current workbook
Ctrl
F4
W
Close Excel
Alt
F4
Q

Ribbon

Expand or collapse ribbon
Ctrl
F1
R
Activate access keys
Alt
Move to next ribbon control
Tab
Tab
Active selected control
Space
Space
Confirm change
Enter
Return
Move one control up
Move one control down
Move one control right
Move one control left

General

Show help
F1
F1
Undo last change
Ctrl
Z
Z
Redo last change
Ctrl
Y
Y
Toggle Autofilter
Ctrl
Shift
L
F

Navigation

Move one cell up
Move one cell down
Move one cell right
Move one cell left
Move one screen up
PgUp
Fn
Move one screen down
PgDn
Fn
Move one screen right
Alt
PgDn
Fn
Move one screen left
Alt
PgUp
Fn
Move to top edge of data region
Ctrl
Move to bottom edge of data region
Ctrl
Move to right edge of data region
Ctrl
Move to left edge of data region
Ctrl
Move to beginning of row
Home
Fn
Show active cell
Ctrl
Backspace
Delete
Move one cell up
Shift
Enter
Return
Move one cell down
Enter
Return
Move one cell right
Tab
Tab
Move one cell left
Shift
Tab
Tab

Selection

Select entire row
Shift
Space
Space
Select entire column
Ctrl
Space
Space
Select region around active cell
Ctrl
A
A
Select entire worksheet
Ctrl
A
A
Add non-adjacent cells to selection
Ctrl
click
click
Expand selection
Shift
click
click
Move right between selections
Ctrl
Alt
Move left between selections
Ctrl
Alt
Toggle add to selection mode
Shift
F8
Fn
F8
Select active cell only
Shift
Backspace
Delete
Move active cell clockwise in selection
Ctrl
.
.
Move active cell down in selection
Enter
Return
Move active cell up in selection
Shift
Enter
Return
Move active cell right in selection
Tab
Tab
Move active cell left in selection
Shift
Tab
Tab
Extend selection by one cell up
Shift
Extend selection by one cell down
Shift
Extend selection by one cell right
Shift
Extend selection by one cell left
Shift
Extend the selection to the last cell up
Ctrl
Shift
Extend the selection to the last cell down
Ctrl
Shift
Extend the selection to the last cell right
Ctrl
Shift
Extend the selection to the last cell left
Ctrl
Shift
Extend selection up one screen
Shift
PgUp
Fn
Extend selection down one screen
Shift
PgDn
Fn
Extend selection to beginning of row
Shift
Home
Fn
Extend selection to first cell in worksheet
Ctrl
Shift
Home
Fn
Extend selection to last cell in data range
Ctrl
Shift
End
Fn
Toggle extend selection mode
F8
Fn
F8
Select region around active cell
Ctrl
Shift
*
Space
Open Name Manager window
Ctrl
F3
L
Create names from selection
Ctrl
Shift
F3
F3

Advanced selection

Open "Go To" window
Ctrl
G
G
Select all cells with comments
Ctrl
Shift
O
Fn
O
Select current array
Ctrl
/
/
Select row differences
Ctrl
\
\
Select column differences
Ctrl
Shift
|
|
Select direct precedents
Ctrl
[
[
Select all precedents
Ctrl
Shift
{
{
Select direct dependents
Ctrl
]
]
Select all dependents
Ctrl
Shift
}
}
Select visible cells only
Alt
;
Z

Copy, cut and paste

Copy selected data
Ctrl
C
C
Cut selected data
Ctrl
X
X
Paste data
Ctrl
V
V
Open Paste special window
Ctrl
Alt
V
V
Cut and paste
drag
drag
Copy and paste
Ctrl
drag
drag
Cut and insert
Shift
drag
drag
Copy and insert
Ctrl
Shift
drag
drag
Cut and paste to different worksheet
Alt
drag
drag
Duplicate worksheet
Ctrl
drag
drag
Copy above cell and paste in active cell
Ctrl
D
D
Copy cell to the left and paste in active cell
Ctrl
R
R
Copy above cell and edit in active cell
Ctrl
"
"
Copy above cell and edit as value in active cell
Ctrl
Shift
"
"

Editing cells

Cancel edition
Esc
Esc
Edit active cell
F2
U
Insert or edit comment
Shift
F2
Fn
F2
Select one character right
Shift
Select one character left
Shift
Move one word right
Ctrl
Move one word left
Ctrl
Select one word right
Ctrl
Shift
Select one word left
Ctrl
Shift
Select to beginning of cell
Shift
Home
Fn
Select to end of cell
Shift
End
Fn
Delete after cursor
Ctrl
Delete
Delete
Delete character to the left
Backspace
Delete
Delete character to the right
Delete
Fn
Delete
Start a new line in the same cell
Alt
Enter
Return

Entering data

Confirm entry and move down
Enter
Return
Confirm entry and move up
Shift
Enter
Return
Confirm entry and move right
Tab
Tab
Confirm entry and move left
Shift
Tab
Tab
Confirm entry and stay in the cell
Ctrl
Enter
Return
Enter data into multiple cells at once
Ctrl
Enter
Return
Insert hyperlink
Ctrl
K
K
Display Autocomplete list
Alt
Flash fill
Ctrl
E

Data formatting

Apply general format
Ctrl
Shift
~
~
Apply currency format
Ctrl
Shift
$
$
Apply percentage format
Ctrl
Shift
%
%
Apply scientific format
Ctrl
Shift
^
^
Apply number format
Ctrl
Shift
!
!

Find and replace

Open Find window
Ctrl
F
F
Open Replace window
Ctrl
H
H
Find next match
Shift
F4
G
Find previous match
Ctrl
Shift
F4
G

Charts

Create chart in current worksheet
Alt
F1
Create chart in new worksheet
F11
Fn
F11

Date and time

Insert current date
Ctrl
;
;
Insert current time
Ctrl
Shift
;
;
Apply date format
Ctrl
Shift
#
#
Apply time format
Ctrl
Shift
@
@

Dialog boxes

Move to next control
Tab
Tab
Move to previous control
Shift
Tab
Tab
Move to next tab
Ctrl
Tab
Tab
Move to previous tab
Ctrl
Shift
Tab
Tab
Apply changes
Enter
Return
Check or uncheck checkbox
Space
Space
Close without saving
Esc
Esc

Formulas

Toggle absolute, relative and mixed references
F4
Y
Open Insert Function window
Shift
F3
Fn
F3
Use autosum
Alt
=
T
Toggle Value / Formula display
Ctrl
`
`
Insert function arguments
Ctrl
Shift
A
A
Confirm entry as array formula
Ctrl
Shift
Enter
Return
Calculate all worksheets in workbook
F9
Fn
F9
Calculate current worksheet
Shift
F9
Fn
F9
Force calculate all worksheets
Ctrl
Alt
F9
Expand the formula bar
Ctrl
Shift
U
U
Move cursor to formula bar
Ctrl
A
A
Paste name into formula
F3
Autocomplete function name
Tab
Tab
Force calculate all worksheets
Ctrl
Shift
Alt
F9

Grid operations

Delete contents of selected cells
Delete
Fn
Delete
Hide or show outline symbols
Ctrl
8
8

Rows and columns

Open Insert window
Ctrl
Shift
+
I
Insert rows
Ctrl
Shift
+
I
Insert columns
Ctrl
Shift
+
I
Open Delete window
Ctrl
-
-
Delete rows
Ctrl
-
-
Delete columns
Ctrl
-
-
Hide columns
Ctrl
0
0
Hide rows
Ctrl
9
9
Unhide columns
Ctrl
Shift
0
0
Unhide rows
Ctrl
Shift
9
9
Group rows or columns
Alt
Shift
K
Ungroup rows or columns
Alt
Shift
J
Open Group window
Alt
Shift
K
Open Ungroup window
Alt
Shift
J

Table

Create table from selected data
Ctrl
T
T
Select table row
Shift
Space
Space
Select table column
Ctrl
Space
Select table
Ctrl
A
A

Visual formatting

Open Format Cells window (last active tab)
Ctrl
1
1
Open Format Cells window (font tab)
Ctrl
Shift
F
Apply most recently used format
F4
Y
Make text bold
Ctrl
B
B
Make text italic
Ctrl
I
I
Underline text
Ctrl
U
U
Strikethrough text
Ctrl
5
X
Apply outside borders
Ctrl
Shift
&
0
Remove borders
Ctrl
Shift
_
_

Workbooks and worksheets

Insert new worksheet
Shift
F11
F11
Go to next worksheet
Ctrl
PgDn
Fn
Go to previous worksheet
Ctrl
PgUp
Fn
Move to next pane
F6
F6
Move to previous pane
Shift
F6
F6
Move to next workbook
Ctrl
Tab
Tab
Move to previous workbook
Ctrl
Shift
Tab
Tab
Minimize current workbook
Ctrl
F9
M
Maximize current workbook
Ctrl
F10
Restore down current workbook
Ctrl
F5
Select adjacent worksheets
Shift
click
click
Select non-adjacent worksheets
Ctrl
click
click
Insert macro sheet
Ctrl
F11

Pivot tables

Select entire pivot table
Ctrl
A
A
Check table field
Space
Space
Group pivot table items
Alt
Shift
K
Ungroup pivot table items
Alt
Shift
J
Hide pivot table item
Ctrl
-
Ctrl
-
Create pivot chart on same worksheet
Alt
F1
Create pivot chart on new worksheet
F11
Fn
F11

Other

Open Spelling window
F7
F7
Open Thesaurus
Shift
F7
F7
Open Macro window
Alt
F8
Fn
F8
Open VBA Editor
Alt
F11
Fn
F11
Snap to grid
Alt
Hide or show objects
Ctrl
6
6
Open Style window
Alt
"
L
Display contextual menu
Shift
F10
Fn
F10
Display contextual menu (fn)
Fn
Display control menu
Alt
Space
?