Keyboard Shorcut yang sering digunakan di Excel
Keyboard Shortcut | Action |
| Ctrl + N | membuka Workbook baru |
| Ctrl + O | membuka Workbook |
| Ctrl + W | Menutup Workbook yang sedang aktif |
| F12 | Save As....beda nama, tempat, dan jenis file |
| Alt + F4 | menutup excel |
| F1 | membuka menu help excel |
| Ctrl + 1 | format any selected object |
| Ctrl + ; | insert current date |
| ctrl + shift + ; | insert current time |
| F4 | repeat last action |
| shift + F2 | edit a cell comment |
| alt + = | autosum selected cells |
| alt + down arrow | see the suggest drop-down in a cell |
| alt + enter | enter multiple lines in a cell |
| shift + F11 | insert a new sheet |
| F2 (places cursor in the end) | edit active cell |
ctrl+9 | hide current row |
| ctrl+0 | hide current column |
ctrl+shift+9 | unhide rows in selected range |
| ctrl+shift+0 | unhide columns in selected range |
F9 | recalculate formulas |
| ctrl+shift+8 | select data in current region |
| ctrl+shift+` (ctrl+~) | see formulas in the worksheet |
| F4 | While editing formulas to change the reference type from absolute to relative vice versa |
| ctrl+shift+4 (ctrl+$) | format a number as currency |
| ctrl+shift+7 | apply outline border around selected cells |
| alt+F8 | open the macros dialog box |
| ctrl+’ | copy value from above cell |
| ctrl+shift+1 | format current cell with comma formats |
| ctrl+shift+pg down | go to the next worksheet |
| ctrl+shift+pg up | go to the previous worksheet |
Tidak ada komentar:
Posting Komentar