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
masterexcelid.com 