Excel Tips: Tombol Shortcut Excel

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
     
     

 

 

 

Tags:
Excel Indonesia, Excel Tutorial, Excel Formula, Excel Function, Excel Tutorial Indonesia, Belajar Excel, Belajar Excel Untuk Pemula, Belajar Excel Pemula, Belajar Excel Untuk Admin, Belajar Excel Lengkap, Belajar Excel Dasar, Belajar Excel Vlookup Hlookup, Belajar Excel Pivot Table, Belajar Excel Macro, Belajar Excel 2007, Belajar Excel 2010, Belajar Excel 2013, Belajar Excel Vlookup, Belajar Excel Rumus, Belajar Excel Tanpa Mouse, Belajar Excel Online, Tutorial Belajar Excel, Tutorial Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: