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.
Shortcut Keys of MS Excel/ Microsoft Office tricks.
Labels:
Grab knowledge,
Latest tricks,
Microsoft
Subscribe to:
Post Comments (Atom)
Related post
- uc browser 9.5 | uc browser 9.5 free download for mobile | uc browser for android
- PicsArt - Photo Studio 3.14.0 | Download PicsArt 3.14.0 Java Mobile App Free
- Top Link Audit Tools for offsite SEO Audit
- Mobo Market 2.0 | Download Mobo Market 2.0 For Mobile Free | android app free download
- Facebook 3.4.1 | Download Facebook 3.4.1 Mobile App Free | Facebook 3.4.1 Software free Download
- My Boy! Free - GBA Emulator 1.5.21 Apk Free Download
- Play KBC 7 : HINDI | Download Play KBC 7 : HINDI Game For Free
- The Sims™ 3 1.5.21 Apk Free Download
- Facebook 3.3.1 | Download Facebook 3.3.1 Mobile App Free | Facebook 3.3.1 Software free Download
- Opera mini 8.5 | Download opera mini 8.5 | Opera mini for Android
No comments:
Post a Comment