Excel Shortcut Keys

On September 13, 2013, in Tips & Tricks, by Herlambang

 

Daftar shortcut pada aplikasi Microsoft Excel

 

Keys

Function

F7 Spell check selected text and or document
F11 Create chart
Ctrl + Shift + ; Enter the current time
Ctrl + ; Enter the current date
Alt + Shift + F1 Insert New Worksheet
Shift + F3 Open the Excel formula window
Shift + F5 Bring up search box
Ctrl + A Select all contents of the worksheet
Ctrl + B Bold highlighted selection
Ctrl + I Italic highlighted selection
Ctrl + K Insert link
Ctrl + U Underline highlighted selection
Ctrl + 5 Strikethrough highlighted selection
Ctrl + P Bring up the print dialog box to begin printing
Ctrl + Z Undo last action
Ctrl + F9 Minimize current window
Ctrl + F10 Maximize currently selected window
Ctrl + F6 Switch between open workbooks / windows
Ctrl + Tab Move to next worksheet
Ctrl + Shift + ! Format number in comma format
Ctrl + Shift + $ Format number in currency format
Ctrl + Shift + # Format number in date format
Ctrl + Shift + % Format number in percentage format
Ctrl + Shift + ^ Format number in scientific format
Ctrl + Shift + @ Format number in time format
Ctrl + Arrow key Move to next section of text
Ctrl + Space Select entire column
Shift + Space Select entire row

 

 

 

Tagged with:  

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

[+] kaskus emoticons