Shortcut keys for Excel

by satheeshkumar 2012-08-15 20:08:17

Shortcut keys for Excel,

F2 - Edit the selected cell.
F5 - Go to a specific cell. For example, C6.
F7 - Spell check selected text 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 or 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.
771
like
0
dislike
0
mail
flag

You must LOGIN to add comments