Tampilkan postingan dengan label shortcut. Tampilkan semua postingan
Tampilkan postingan dengan label shortcut. Tampilkan semua postingan

Kamis, 07 April 2011

Excel Keyboard shortcut


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