Microsoft Excel 50 Most Useful Shortcut Keys |
||
| Sr.no | Short Cut | Use |
| 1 | Ctrl+F1 | Expand or collapse ribbon |
| 2 | Ctrl+F2 | To See The Print Preview |
| 3 | F2 | Edit Cell |
| 4 | Ctrl+Space bar | Select Single Column |
| 5 | Ctrl+0 | Hide Column |
| 6 | Shift+Space bar | Select Single Row |
| 7 | Ctrl+9 | Hide Row |
| 8 | Ctrl+Shift+9 | UN-hide Row |
| 9 | Ctrl- | Delete Row/Column |
| 10 | Ctrl+ | Insert Row / Column |
| 11 | Ctrl+shift+: | Insert Time |
| 12 | Ctrl+; | Insert Date |
| 13 | Ctrl+Shift+L | Apply Filter |
| 14 | Ctrl+R | Fill Right |
| 15 | Ctrl+D | Fill Down |
| 16 | Ctrl+Enter | Enter Same Data in Selected Area |
| 17 | Ctrl+shift+Space bar | Select Entire Data |
| 18 | Ctrl+Down Arrow | Move to bottom |
| 19 | Ctrl+Up Arrow | Move to top |
| 20 | Ctrl+Page Down | Move on Next Sheet |
| 21 | Ctrl+Page Up | Move on Previous Sheet |
| 22 | Ctrl+Tab | Move Between 2 or more Workbook |
| 23 | Shift+
Up/Down/Right/Left Arrow Keys |
Extend Selection
Up/Down/Right/Left Direction |
| 24 | Ctrl+Shift+Right Arrow Key | Extend the selection to the last cell on the right |
| 25 | Ctrl+Shift+Down Arrow | Extend the selection to the last Bottom cell |
| 26 | Alt+= | Auto Sum |
| 27 | Ctrl+G/F5 | Go to |
| 28 | F11 | Create Chart |
| 29 | Shift+F8 | Add to Selection |
| 30 | Shift+F11 | Insert New Sheet |
| 31 | Ctrl+T | Create Table |
| 32 | ALT+O+H+R | Rename Sheet |
| 33 | Alt+E+L | Delete Sheet |
| 34 | Ctrl+Mouse Wheel Up Down | Zoom In /Zoom Out |
| 35 | Alt+H+B+A | Apply Border in Selected Area |
| 36 | Ctrl+Shift- | Remove Border In Selected Area |
| 37 | Tab | Move right side in cell.Insert Formula with Bracket |
| 38 | Alt+P+R+S | Set Print Area |
| 39 | Alt+P+R+C | Clear Print Area |
| 40 | Alt+R+P+S | Protect Work Book |
| 41 | Ctrl+P | |
| 42 | Ctrl+F9 | Minimize current workbook window |
| 43 | Alt+H+S+S | Ar-rage Data In Acceding Order |
| 44 | Page Up | Move one screen up |
| 45 | Page Down | Move one screen down |
| 46 | SHIFT + CTRL + $ | $ Dollar Format |
| 47 | SHIFT + F2 | Insert a Comment |
| 48 | Alt + R + A | Show all comments |
| 49 | Ctrl+W | Close Window |
| 50 | Alt+Enter | Wrap Text |
इन शॉर्टकट की का उपयोग वीडियो में माध्यम से समझने के लिए वीडियो पे क्लिक करें।
Leave a Reply