Berhubung ada teman yang request, jadi kami tampilkan shortcut pada Ms. Excel. Berikut Selengkapnya :
File
File
Windows
|
Mac
|
|
Create new
workbook
|
Ctrl + N
|
⌘ + N
|
Open workbook
|
Ctrl
+ O
|
⌘ + O
|
Save workbook
|
Ctrl + S
|
⌘ + S
|
Save as
|
F12
|
⌘ + ⇧ + S
|
Print file
|
Ctrl + P
|
⌘ + P
|
Open print preview window
|
Ctrl
+ F2
|
|
Close current workbook
|
Ctrl + F4
|
⌘ + W
|
Close Excel
|
Alt
+ F4
|
⌘ + Q
|
Ribbon
|
|
Windows
|
Mac
|
|
Expand
or collapse ribbon
|
Ctrl + F1
|
⌘
+ ⌥ + R
|
|
Activate access keys
|
Alt
|
|
|
Move
to next ribbon control
|
Tab
|
Tab
|
|
Activate or open selected control
|
Space
|
Space
|
|
Confirm
control change
|
Enter
|
Return
|
|
Get help on selected control
|
F1
|
|
Umum
|
|
Windows
|
Mac
|
|
Open
help
|
F1
|
⌘
+ /
|
|
Undo last action
|
Ctrl
+ Z
|
⌘ + Z
|
|
Redo
last action
|
Ctrl + Y
|
⌘
+ Y
|
|
Copy selected cells
|
Ctrl
+ C
|
⌘ + C
|
|
Repeat
last action
|
F4
|
⌘
+ Y
|
|
Cut
selected cells
|
Ctrl
+ X
|
⌘ + X
|
|
Paste
content from clipboard
|
Ctrl + V
|
⌘
+ V
|
|
Display the Paste Special dialog box
|
Ctrl
+ Alt + V
|
^ + ⌘ + V
|
|
Display
find and replace
|
Ctrl + F
|
⌘
+ F
|
|
Display find and replace, replace selected
|
Ctrl
+ H
|
^ + H
|
|
Find
previous match
|
Ctrl + Shift + F4
|
⌘
+ ⇧ + G
|
|
Find next match
|
Shift
+ F4
|
⌘ + G
|
|
Create
embedded chart
|
Alt + F1
|
Fn
+ ⌥ + F1
|
|
Create chart in new worksheet
|
F11
|
Fn + F11
|
|
Toggle
Autofilter
|
Ctrl + Shift + L
|
⌘
+ ⇧ + F
|
|
Activate filter
|
Alt
+ ↓
|
⌥ + ↓
|
|
Insert
table
|
Ctrl + T
|
^ + T
|
|
Select table row
|
Shift
+ Space
|
⇧
+ Space
|
|
Select
table column
|
Ctrl + Space
|
^
+ Space
|
|
Select table
|
Ctrl
+ A
|
⌘ + A
|
|
Clear
slicer filter
|
Alt + C
|
⌥ + C
|
Drag and Drop
|
|
Windows
|
Mac
|
|
Drag and cut
|
drag
|
Drag
|
|
Drag and copy
|
Ctrl
+ drag
|
⌥
+ Drag
|
|
Drag and insert
|
Shift + Drag
|
⇧ + Drag
|
|
Drag and insert copy
|
Ctrl
+ Shift + Drag
|
⌥ + ⇧ + drag
|
|
Drag to worksheet
|
Alt + drag
|
⌘ + drag
|
|
Drag to duplicate worksheet
|
Ctrl + drag
|
⌥ + drag
|
Navigation
|
|
Windows
|
Mac
|
|
Move one cell right
|
→
|
→
|
|
Move one cell left
|
←
|
←
|
|
Move one cell up
|
↑
|
↑
|
|
Move one cell down
|
↓
|
↓
|
|
Move one screen right
|
Alt
+ PgDn
|
Fn + ⌥
+ ↓
|
|
Move one screen left
|
Alt + PgUp
|
Fn + ⌥
+ ↑
|
|
Move one screen up
|
PgUp
|
Fn + ↑
|
|
Move one screen down
|
PgDn
|
Fn + ↓
|
|
Move to right edge of data region
|
Ctrl
+ →
|
⌃ + →
|
|
Move to left edge of data region
|
Ctrl + ←
|
⌃
+ ←
|
|
Move to top edge of data region
|
Ctrl
+ ←
|
⌃ + ↑
|
|
Move to bottom edge of data region
|
Ctrl + ←
|
⌃
+ ↓
|
|
Move to beginning of row
|
Home
|
Fn + ←
|
|
Move to last cell in worksheet
|
Ctrl + End
|
Fn + ⌃
+ →
|
|
Move to first cell in worksheet
|
Ctrl
+ Home
|
Fn + ⌃ + ←
|
|
Turn End mode on
|
End
|
Fn + →
|
→
Selection
|
|
Windows
|
Mac
|
|
Select entire row
|
Shift + Space
|
⇧ + Space
|
|
Select entire column
|
Ctrl + Space
|
⌃ + Space
|
|
Select entire worksheet
|
Ctrl + A
|
⌘ + A
|
|
Add adjacent cells to selection
|
Shift + Click
|
⇧ + Click
|
|
Add non-adjacent cells to selection
|
Ctrl + Click
|
⌘ + Click
|
|
Same selection in next column
|
|
⌥ + Tab
|
|
Same selection in previous column
|
|
⌥ + ⇧ + Tab
|
|
Move right between non-adjacent selections
|
Ctrl + Alt + →
|
⌃ + ⌥ + →
|
|
Move left between non-adjacent selections
|
Ctrl + Alt + ←
|
⌃ + ⌥ + ←
|
|
Toggle add to selection mode
|
Shift + F8
|
Fn + ⇧ + F8
|
|
Cancel selection
|
Esc
|
Esc
|
Active Cell
|
|
Windows
|
Mac
|
|
Select active cell only
|
Shift + Backspace
|
⇧ + Delete
|
|
Show the active cell on worksheet
|
Ctrl + 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 a selection
|
Tab
|
Tab
|
|
Move active cell left in a selection
|
Shift + Tab
|
⇧ + Tab
|
Extend Selection
|
|
Windows
|
Mac
|
|
Extend selection by one cell right
|
Shift + →
|
⇧ + →
|
|
Extend selection by one cell left
|
Shift + ←
|
⇧ + ←
|
|
Extend selection by one cell up
|
Shift + ↑
|
⇧ + ↑
|
|
Extend selection by one cell down
|
Shift + ↓
|
⇧ + ↓
|
|
Extend the selection to the last cell right
|
Ctrl + Shift + →
|
⌃ + ⇧ + →
|
|
Extend the selection to the last cell left
|
Ctrl + Shift + ←
|
⌃ + ⇧ + ←
|
|
Extend the selection to the last cell up
|
Ctrl + Shift + ↑
|
⌃ + ⇧ + ↑
|
|
Extend the selection to the last cell down
|
Ctrl + Shift + ↓
|
⌃ + ⇧ + ↓
|
|
Extend selection up one screen
|
Shift + PgUp
|
Fn + ⇧ + ↑
|
|
Extend selection down one screen
|
Shift + PgDn
|
Fn + ⇧ + ↓
|
|
Extend selection right one screen
|
Alt + Shift +
PgDn
|
Fn + ⇧ + ⌘ + ↓
|
|
Extend selection left one screen
|
Alt + Shift + PgUp
|
Fn + ⇧ + ⌘ + ↑
|
|
Extend selection to start of row
|
Shift + Home
|
Fn + ⇧ + ←
|
|
Extend selection to first cell in worksheet
|
Ctrl + Shift + Home
|
Fn + ⌃ + ⇧ + ←
|
|
Extend selection to last cell in worksheet
|
Ctrl + Shift + End
|
Fn + ⌃ + ⇧ + →
|
|
Toggle extend selection mode
|
F8
|
Fn + F8
|
Select Special
|
|
Windows
|
Mac
|
|
Display 'Go To' dialog box
|
Ctrl + G
|
⌃ + G
|
|
Select cells with comments
|
Ctrl + Shift + O
|
Fn + ⌃ + ⇧ + O
|
|
Select current region around active cell
|
Ctrl + Shift + *
|
⇧ + ⌃ + Space
|
|
Select current region
|
Ctrl + A
|
⌘ + A
|
|
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
|
Cell edit mode
|
|
Windows
|
Mac
|
|
Edit the active cell
|
F2
|
⌃ + U
|
|
Insert or edit comment
|
Shift + F2
|
Fn + ⇧ + F2
|
|
Cancel entry
|
Esc
|
Esc
|
|
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 to end of line
|
Ctrl + Delete
|
⌃ + Delete
|
|
Delete character to the left of cursor
|
Backspace
|
Delete
|
|
Delete character to the right of cursor
|
Delete
|
Fn + Delete
|
|
Start a new line in the same cell
|
Alt + Enter
|
⌃ + ⌥ + Return
|
Entering data
|
|
Windows
|
Mac
|
|
Enter and move down
|
Enter
|
Return
|
|
Enter and move up
|
Shift
+ Enter
|
⇧ + Return
|
|
Enter and move right
|
Tab
|
Tab
|
|
Enter and move left
|
Shift
+ Tab
|
⇧ + Tab
|
|
Complete entry and stay in same cell
|
Ctrl + Enter
|
⌃ + Return
|
|
Enter same data in multiple cells
|
Ctrl + Enter
|
⌃ + Return
|
|
Insert current date
|
Ctrl + ;
|
⌃ + ;
|
|
Insert current time
|
Ctrl + Shift
+ :
|
⌃ + ⇧ + :
|
|
Fill down from cell above
|
Ctrl + D
|
⌃ + D
|
|
Fill right from cell left
|
Ctrl + R
|
⌃ + R
|
|
Copy formula from cell above
|
Ctrl + Shift + ‘
|
⌃ + '
|
|
Copy value from cell above
|
Ctrl + “
|
⌃ + ⇧ + "
|
|
Add hyperlink
|
Ctrl + K
|
⌘ + K
|
|
Display AutoComplete list
|
Alt + ↓
|
⌥ + ↓
|
|
Flash fill
|
Ctrl + E
|
|
CtrlE
Formatting
|
|
Windows
|
Mac
|
|
Format (almost) anything
|
Ctrl + 1
|
⌘ + 1
|
|
Display Format Cells with Font tab selected
|
Ctrl + Shift + F
|
⌃ + ⇧ + F
|
|
Apply or remove bold formatting
|
Ctrl + B
|
⌘ + B
|
|
Apply or remove italic formatting
|
Ctrl + I
|
⌘ + I
|
|
Apply or remove underscoring
|
Ctrl + U
|
⌘ + U
|
|
Apply or remove strikethrough formatting
|
Ctrl + 5
|
⌘ + ⇧ + X
|
|
Add or remove the shadow font style
|
|
⌘ + ⇧ + W
|
|
Add or remove the outline font style
|
|
⌘ + ⇧ + D
|
|
Align center
|
Alt + H + A + C
|
⌘ + E
|
|
Align left
|
Alt + H + A + L
|
⌘ + L
|
|
Align right
|
Alt + H + A + R
|
⌘ + R
|
|
Indent
|
Alt + H + 6
|
⌃ + ⌥ + Tab
|
|
Remove indent
|
Alt + H + 5
|
⌃ + ⌥ + ⇧ + Tab
|
|
Increase font size one step
|
Alt + H + FG
|
⌘ + ⇧ + >
|
|
Decrease font size one step
|
Alt + + H + FK
|
⌘ + ⇧ + <
|
Number Formatting
|
|
Windows
|
Mac
|
|
Apply general format
|
Ctrl + Shift + ~
|
⌃ + ⇧ + ~
|
|
Apply currency format
|
Ctrl + Shift + $
|
⌃ + ⇧ + $
|
|
Apply percentage format
|
Ctrl + Shift + %
|
⌃ + ⇧ + %
|
|
Apply scientific format
|
Ctrl + Shift + ^
|
⌃ + ⇧ + ^
|
|
Apply date format
|
Ctrl + Shift + #
|
⌃ + ⇧ + #
|
|
Apply time format
|
Ctrl + Shift + @
|
⌃ + ⇧ + @
|
|
Apply number format
|
Ctrl + Shift + !
|
⌃ + ⇧ + !
|
Borders
|
|
Windows
|
Mac
|
|
Add border outline
|
Ctrl + Shift + &
|
⌘ + ⌥ + 0
|
|
Add or remove border right
|
Alt
+ R
|
⌘ + ⌥ + →
|
|
Add or remove border left
|
Alt + L
|
⌘ + ⌥ + ←
|
|
Add or remove border top
|
Alt
+ T
|
⌘ + ⌥ + ↑
|
|
Add or remove border bottom
|
Alt + B
|
⌘ + ⌥ + ↓
|
|
Add or remove border upward diagonal
|
Alt
+ D
|
|
|
Add or remove border horizontal interior
|
Alt + H
|
|
|
Add or remove border vertical interior
|
Alt
+ V
|
|
|
Remove borders
|
Ctrl + Shift + _
|
⌘ + ⌥ + _
|
Formulas
|
|
Windows
|
Mac
|
|
Toggle absolute and relative references
|
F4
|
⌘ + T
|
|
Open the Insert Function Dialog Box
|
Shift + F3
|
Fn + ⇧ + F3
|
|
Autosum selected cells
|
Alt + =
|
⌘ + ⇧ + T
|
|
Toggle formulas on and off
|
Ctrl + `
|
⌃ + `
|
|
Insert function arguments
|
Ctrl + Shift + A
|
⌃ + ⇧ + A
|
|
Enter array formula
|
Ctrl + Shift + Enter
|
⌃ + ⇧ + Return
|
|
Calculate worksheets
|
F9
|
Fn + F9
|
|
Calculate active worksheet
|
Shift + F9
|
Fn + ⇧ + F9
|
|
Force calculate all worksheets
|
Ctrl + Alt + F9
|
|
|
Evaluate part of a formula
|
F9
|
Fn + F9
|
|
Expand or collapse the formula bar
|
Ctrl + Shift + U
|
⌃ + ⇧ + U
|
|
Display function arguments dialog box
|
Ctrl + A
|
⌃ + A
|
|
Define name
|
Ctrl + F3
|
Fn + ⌃ + F3
|
|
Define name using row and column labels
|
Ctrl + Shift + F3
|
Fn + ⌃ + ⇧ + F3
|
|
Paste name into formula
|
F3
|
|
|
Accept function with autocomplete
|
Tab
|
↓ + Tab
|
ShiftF9
Grid Operations
|
|
Windows
|
Mac
|
|
Display Insert Dialog box
|
Ctrl + Shift + +
|
⌃+ I
|
|
Insert rows
|
Ctrl + Shift + +
|
⌃ + I
|
|
Insert columns
|
Ctrl + Shift + +
|
⌃ + I
|
|
Display Delete dialog box
|
Ctrl + -
|
⌃ + -
|
|
Delete rows
|
Ctrl + -
|
⌃ + -
|
|
Delete columns
|
Ctrl + -
|
⌃ + -
|
|
Delete cells
|
Ctrl + -
|
⌃ + -
|
|
Delete contents of selected cells
|
Delete
|
Fn + Delete
|
|
Hide columns
|
Ctrl + 0
|
⌃ + 0
|
|
Hide rows
|
Ctrl + 9
|
⌃ + 9
|
|
Unhide rows
|
Ctrl + Shift + 9
|
⌃ + ⇧ + 9
|
|
Unhide columns
|
Ctrl + Shift + 0
|
⌃ + ⇧ + 0
|
|
Group rows or columns
|
Alt + Shift + →
|
⌘ + ⇧ + K
|
|
Ungroup rows or columns
|
Alt + Shift + ←
|
⌘ + ⇧ + J
|
|
Open Group Dialog Box
|
Alt + Shift + →
|
⌘ + ⇧ + K
|
|
Open Ungroup Dialog Box
|
Alt + Shift + ←
|
⌘ + ⇧ + J
|
|
Hide or show outline symbols
|
Ctrl + 8
|
⌃ + 8
|
|
Zoom in
|
Ctrl + +
|
⌥ + ⌘ + +
|
|
Zoom out
|
Ctrl + -
|
⌥ + ⌘ + -
|
Pivot Tables
|
|
Windows
|
Mac
|
|
Select entire pivot table
|
Ctrl + A
|
⌘ + A
|
|
Toggle pivot table field checkbox
|
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
|
|
Open pivot table wizard
|
Alt + D + P
|
⌘ + ⌥ + P
|
Workbook
|
|
Windows
|
Mac
|
|
Insert new worksheet
|
Shift + F11
|
Fn + ⇧ + F11
|
|
Go to next worksheet
|
Ctrl + PgDn
|
Fn + ⌃ + ↓
|
|
Go to previous worksheet
|
Ctrl + PgUp
|
Fn + ⌃ + ↑
|
|
Move to next pane
|
F6
|
Fn + F6
|
|
Move to previous pane
|
Shift + F6
|
Fn + ⇧ + F6
|
|
Go to next workbook
|
Ctrl + Tab
|
⌃ + Tab
|
|
Go to previous workbook
|
Ctrl + Shift +
Tab
|
⌃ + ⇧ + Tab
|
|
Minimize current workbook window
|
Ctrl + F9
|
⌘ + M
|
|
Maximize current workbook window
|
Ctrl + F10
|
fn + ⌃ + F10
|
|
Select adjacent worksheets
|
Shift + Click
|
⇧ + Click
|
|
Select non-adjacent worksheets
|
Ctrl + Click
|
⌘ + Click
|
|
Toggle scroll lock
|
ScrLk
|
Fn + ⇧ + F14
|
|
Toggle full screen
|
Ctrl + Shift +
F1
|
⌃ + ⌘ + F
|
Dialog boxes
|
|
Windows
|
Mac
|
|
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
|
|
Accept and apply
|
Enter
|
Return
|
|
Check and uncheck box
|
Space
|
Space
|
|
Cancel and close the dialog box
|
Esc
|
Esc
|
Other
|
|
Windows
|
Mac
|
|
Open Spelling dialog box
|
F7
|
Fn + F7
|
|
Open Thesaurus dialog box
|
Shift + F7
|
Fn + ⇧ + F7
|
|
Open Macro dialog box
|
Alt + F8
|
Fn + ⌥ + F8
|
|
Open VBA Editor
|
Alt + F11
|
Fn + ⌥ + F11
|
|
Duplicate object
|
Ctrl + D
|
⌘ + D
|
|
Snap to grid
|
Alt
|
⌘
|
|
Hide or show objects
|
Ctrl + 6
|
⌃ + 6
|
|
Display Modify Cell Style dialog box
|
Alt + ‘
|
⌘ + ⇧ + L
|
|
Display right-click menu
|
Shift + F10
|
Fn + ⇧ + F10
|
|
Delete comment
|
Shift + F10 + D
|
fn + Shift + F10
|
|
Display control menu
|
Alt + Space
|
?
|
Semoga Bermanfaat!!!
Sumber : https://exceljet.net/keyboard-shortcuts
ShiftF10D
Comments
Post a Comment