Shortcut Keys Description 
F2 Edit the selected cell. 
F5 Goto a specific cell. For example, C6. 
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 + Page up Move between Excel work sheets in the same Excel document. 
Ctrl + Page down Move between Excel work sheets in the same Excel document. 
Ctrl + Tab Move between Two or more open Excel files. 
Alt + = Create a formula to sum all of the above cells 
Ctrl + ' Insert the value of the above cell into cell currently selected. 
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.
 
 
No comments:
Post a Comment