MS EXCEL Formula |
Description |
Ctrl+A | Select All |
Ctrl+B | Bold |
Ctrl+C | Copy |
Ctrl+D | Fill Down |
Ctrl+F | Find |
Ctrl+G | Goto |
Ctrl+H | Replace |
Ctrl+I | Italic |
Ctrl+K | Insert Hyperlink |
Ctrl+N | New Workbook |
Ctrl+O | Open |
Ctrl+P | |
Ctrl+R | Fill Right |
Ctrl+S | Save |
Ctrl+U | Underline |
Ctrl+V | Paste |
Ctrl W | Close |
Ctrl+X | Cut |
Ctrl+Y | Repeat |
Ctrl+Z | Undo |
F1 | Help |
F2 | Edit |
F3 | Paste Name |
F4 | Repeat last action |
F5 | Goto |
F6 | Next Pane |
F7 | Spell check |
F8 | Extend mode |
F9 | Recalculate all workbooks |
F10 | Activate Menubar |
F11 | New Chart |
F12 | Save As |
Ctrl+: | Insert Current Time |
Ctrl+; | Insert Current Date |
Ctrl+" | Copy Value from Cell Above |
Ctrl+’ | Copy Formula from Cell Above |
Shift | Hold down shift for additional functions in Excel’s menu |
Shift+F1 | What’s This? |
Shift+F2 | Edit cell comment |
Shift+F3 | Paste function into formula |
Shift+F4 | Find Next |
Shift+F5 | Find |
Shift+F6 | Previous Pane |
Shift+F8 | Add to selection |
Shift+F9 | Calculate active worksheet |
Shift+F10 | Display shortcut menu |
Shift+F11 | New worksheet |
Shift+F12 | Save |
Ctrl+F3 | Define name |
Ctrl+F4 | Close |
Ctrl+F5 | XL, Restore window size |
Ctrl+F6 | Next workbook window |
Shift+Ctrl+F6 | Previous workbook window |
Ctrl+F7 | Move window |
Ctrl+F8 | Resize window |
Ctrl+F9 | Minimize workbook |
Ctrl+F10 | Maximize or restore window |
Ctrl+F11 | Inset 4.0 Macro sheet |
Ctrl+F12 | File Open |
Alt+F1 | Insert Chart |
Alt+F2 | Save As |
Alt+F4 | Exit |
Alt+F8 | Macro dialog box |
Alt+F11 | Visual Basic Editor |
This blog is to inspire people and let them achieve excellence in their careers.It also helps to gain knowledge , especially for commerce students.There are many posts to gain general knowledge.....
Friday, 24 February 2017
MS Excel all formulas at one palce
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment