
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