shortcut keys
SHORTCUT KEYS IN EXCEL | ||
Ctrl+E: - | Full Fill All Cell | |
Ctrl+Page Up/Down: - | Jump To Another Sheet | |
Shift+Right/Left Arrow: - | Cell Selection | |
Shift+BackSpace: - | Row Select | |
Ctrl+Space: - | Column Select | |
Ctrl+Shift+Space/Ctrl+A: - | All cell Select | |
Ctrl+Home: - | Jump To Direct First Cell | |
Ctrl+End: - | Last Cell | |
Page Up/Down: - | Celling Scroll | |
Alt+Page Up: - | Right Side | |
Alt+Page Down: - | Left Side | |
Fn+f8+down Arrow: - | All Cell Selection | |
Ctrl+W: - | Close | |
Ctrl+F4: - | Close | |
Alt+Space+C: - | Close | |
F4/Fn+F4: - | Last Command Repeat | |
Shift+F11/Shift+Fn+F11/Ctrl+N: - | New Worksheet | |
Ctrl+O: - | Old File Open | |
Fn+F12: - | Multiple save file or document | |
Ctrl+P: - | Print | |
Fn+1: - | Help in excel | |
Fn+7: - | Spelling checks | |
Fn+F9/F9: - | calculate seen the value | |
Alt+V+Z: - | Zoom in/Zoom Out | |
Alt+F10/Alt+F10+Fn: - | To View Shortcut Key in Tab | |
Ctrl+F1 | Hide/Show Ribbon | |
Ctrl+Shift+U: - | To Expand Formula Bar | |
Ctrl+F9: - | Minimize Workbook | |
F11/Fn+F11: - | View Chart | |
Alt+F1: - | View Chart in Same Worksheet | |
Alt+H: - | Home Key | |
Ctrl+Tab: - | Switch To Another Workbook | |
Shift+F3: - | Insert Function | |
Alt+F8: - | Run Macro | |
Alt+F11: - | VBA (Visual Basic Application) | |
Shift+Tab: - | Jump To Previous Cell | |
F5/Ctrl+G | Go to Any File | |
F2+Fn: - | Edit Mode | |
Shift+F2: - | Add Comment Cell | |
Alt+Enter: - | Write in Next Line of Same Cell | |
Alt+H+H: - | To Assign Color to cell | |
Alt+H+B+A: - | All Border Select | |
Ctrl+Shift+&: - | Outline Border | |
Ctrl+Shift+___: - | Remove outline Border | |
Ctrl+9: - | Hide Row | |
Ctrl+0: - | Unhide Row | |
Ctrl+1: - | Format Cell | |
Ctrl+5: - | Strike-Through | |
Ctrl+Shift+$: - | Currency Format | |
Ctrl+Shift+#: - | To Apply Date Format | |
Time Format | ||
Ctrl+Shift+! : - | To apply Number Format | |
Ctrl+Shift+~: - | To Apply General Format | |
Ctrl+ ‘: - | Copy From Above Cell | |
Ctrl+ D: - | Fill Down all Cell | |
Ctrl+ R: - | Fill Down Right Cell | |
Ctrl+ F10: - | Excel Screen Minimize/Restore | |
Ctrl+ F9: - | Minimize | |
Ctrl+ F12: - | Open Dialogue Box | |
Ctrl+Shift +F1: - | Hide Tab and Ribbon | |
Alt+ U + V: - | Full Screen | |
Ctrl+ Shift + F3: - | Create Name Range | |
Alt+W + H: - | Wrap text | |
Ctrl+ Shift+ Page Down/Page Up: - | Select Multiple sheets | |
Ctrl +; : - | Current Date | |
Ctrl+ Shift + : : - | Current Time | |
Ctrl + T/ L : - | Create Table | |
Alt + H + O +R: - | Change Sheet Name | |
Ctrl + K: - | Hyperlink text | |
Ctrl + Shift + A: - | All Argument Seen in Excel of VLOOKUP | |
Alt + N + v: - | Pivot Table | |
Alt + = : - | Auto Sum Function | |
Alt +H + M + C: - | Merger and Center | |
Ctrl + ~(Tiled): - | Show/Hide Formulas | |
Alt + Shift +Enter: - | Create Array | |
Alt+ A + Q: - | Advance Filter | |
Alt+ H +O + I: - | Auto Column Width | |
Good
ReplyDelete