| 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