F2 : Edit the selected cell.
F5: Go to a specific cell .
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: Strike through highlighted selection.
Ctrl+P: Bring up the print dialogue box to bring printing.
Ctrl+Z: Undo last action.
Ctrl+F9: Minimize current window.
Ctrl+F10: Maximize current window.
Ctrl+F6: Switch between open work books/windows.
Ctrl+Page down: Move between Excel worksheets in the same excel document.
Ctrl+Tab: move between two or more excel files.
Alt+=: Create a formula to sum all of the above cells.
Ctrl+' : Insert the value of the above cell into the cell currently selected.
Ctrl+shift+! : Format number in comma format.
Ctrl+Shift+$ : Format number in currency format.
Ctrl+Shift+# : Format number in date format.
Crtl+Shift+% : Format number in percentage format.
Crtl+Shift+^ : Format number in scientific format.
Crtl+Shift+@ : Format number in time format.
Crtr+Arrow key : move to next section.
Ctrl+Space: Select the entire colum.
Shift +Space : Select entire row.
Tuesday 12 November 2013
Shortcut Keys of MS Excel/ Microsoft Office tricks.
Posted on 03:47 by Unknown
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment