Hello Guys, di postingan kali ini gue mau share tentang tombol tombol yang useful untuk mempercepat data processing kita sehari hari dengan Microsoft Excel:
Fungsi
|
Windows
|
Mac
|
FILE
| ||
Create New Workbook
|
Ctrl + N
|
Mac + N
|
Open Workbook
|
Ctrl + O
|
Mac + O
|
Save Workbook
|
Ctrl + S
|
Mac + S
|
Save As
|
F12
|
Mac + Shift + S
|
Print File
|
Ctrl + P
|
Mac + P
|
Print Preview
|
Ctrl + F2
| |
Close Current Workbook
|
Ctrl + F4 /
Ctrl + W
|
Mac + W
|
Close Excel
|
Alt + F4
|
Mac + Q
|
GENERAL
| ||
Open Option
|
Alt, F, T
|
Mac + ,
|
Open Help
|
F1
|
Mac + /
|
Undo
|
Ctrl + Z
|
Mac + Z
|
Redo
|
Ctrl + Y
|
Mac + Y
|
Repeat Last Action
|
F4
|
Mac + Y
|
Copy selected cells
|
Ctrl + C
|
Mac + C
|
Cut selected cells
|
Ctrl + X
|
Mac + X
|
Paste (Copy / Cut First)
|
Ctrl + V
|
Mac + V
|
Paste Special (Copy / Cut First)
|
Ctrl + Alt + V
|
^ + Mac + V
|
Find / Replace
|
Ctrl + F
|
Mac + F
|
Find Next Match
|
Shift + F4
|
Mac + G
|
Find Previous Match
|
Ctrl + Shift + F4
|
Mac + Shift + G
|
Create Chart in new Worksheet
|
F11
| |
TABLE & FILTER
| ||
Insert Table
|
Ctrl + T
|
^ + T
|
Toggle Autofilter
|
Ctrl + Shift + L
|
Mac + Shift + F
|
Activate Filter (Filter First)
|
Alt + Down
| |
Select Entire Row
|
Shift + Space
|
Shift + Space
|
Select Entire Column
|
Ctrl + Space
|
^ + Space
|
Select Region (Or All Cells)
|
Ctrl + A
|
Mac + A
|
NAVIGATION
| ||
Move To Last Cell Right
|
Ctrl + Right
|
^ + Right
|
Move To Last Cell Left
|
Ctrl + Left
|
^ + Left
|
Move To Last Cell Up
|
Ctrl + Up
|
^ + Up
|
Move To Last Cell Down
|
Ctrl + Down
|
^ + Down
|
SELECTION
| ||
Select Entire Row
|
Shift + Space
|
Shift + Space
|
Select Entire Column
|
Ctrl + Space
|
^ + Space
|
Select Entire Worksheet
|
Ctrl + A
|
Mac + A
|
Select Multiple Cells
|
Ctrl + Click /
Shift + Click
| |
Cancel Selection
|
Esc
|
Esc
|
Extend Selection (Up / Down / Right / Left)
|
Shift + Arrow
|
Shift + Arrow
|
Extend Selection to Last Cell
(Up / Down / Right / Left)
|
Ctrl + Shift + Arrow
|
^ + Shift + Arrow
|
CELLS EDIT
| ||
Edit Active Cell
|
F2
|
^ + U
|
Insert / Edit Comment
|
Shit + F2
|
Fn + ^ + F2
|
Cancel Edit
|
Esc
|
Esc
|
Select Multiple Character
|
Shift + Arrow
|
Shift + Arrow
|
Move
|
Arrow
|
Arrow
|
Select One Word
|
Ctrl + Shift + Arrow
|
^ + Shift + Arrow
|
FORMATTING
| ||
Bold
|
Ctrl + B
|
Mac + B
|
Italic
|
Ctrl + I
|
Mac + I
|
Underscores
|
Ctrl + U
|
Mac + U
|
Apply General Format
|
Ctrl + Shift + ~
|
^ + Shift + ~
|
Apply Currency Format
|
Ctrl + Shift + $
|
^ + Shift + $
|
Apply Percentage Format
|
Ctrl + Shift + %
|
^ + Shift + %
|
Apply Scientific Format
|
Ctrl + Shift + ^
|
^ + Shift + ^
|
Apply Date Format
|
Ctrl + Shift + #
|
^ + Shift + #
|
Apply Time Format
|
Ctrl + Shift + @
|
^ + Shift + @
|
Apply Number Format
|
Ctrl + Shift + !
|
^ + Shift + !
|
Remove Border (Apply Border First)
|
Ctrl + Shift + _
| |
Insert Rows / Column
|
Ctrl + Shift + +
|
^ + I
|
Delete Row / Column
|
Ctrl + -
|
^ + -
|
Zoom
|
Ctrl + Scroll /
Ctrl + Alt + +/-
| |
WORKSHEET
| ||
Next Worksheet
|
Ctrl + PgDown
|
Fn + ^ + Down
|
Previous Worksheet
|
Ctrl + PgUp
|
Fn + ^ + Up
|
Next Workbook
|
Ctrl + Tab
|
^ + Tab
|
Previous Workbook
|
Ctrl + Shift + Tab
|
^ + Shift + Tab
|
Minimize Current Workbook Windows
|
Ctrl + F9
|
Mac + M
|
Maximize Current Workbook Windows
|
Ctrl + F10
|
Fn + ^ + F10
|
Select Multiple Sheet
|
Ctrl / Shift + Click
|
Shift / Mac + Click
|
ON INSERT FORMULA
| ||
Absolute / Relative Reference
|
F4
|
Mac + T
|
Autosum
|
Alt + =
|
Mac + Shift + T
|
