In order to find out details about RAM, OS, Processor speed we all have been doing below set of steps…
But there is a smarter way of doing this. To quickly view the system properties simply hold “Win” Key on your keyboard and then press “Pause/Break” key.
I hope you found the information useful and Thank you for reading.
You may want to keep below set of key sequences handy as it can definitely improve your productivity while working with Excel.
| Task | Key Sequence |
| Hide Column | [Ctrl] + [0] |
| Unhide Column | [Ctrl] + [Shift] + [0] |
| Hide Row | [Ctrl] + [9] |
| Unhide Row | [Ctrl] + [Shift] + [9] |
| Refresh | [Ctrl] + [6] |
| Strike Out | [Ctrl] + [5] |
| Underline | [Ctrl] + [4] |
| Italic | [Ctrl] + [3] |
| Bold | [Ctrl] + [2] |
| Format Cell Dialog | [Ctrl] + [1] |
| Change Relative Cell Ref to Absolute ref. (Toggle Key) | [F4] |
| Edit Current Cell | [F2] |
| vzGo To a Cell | [F5] |
| Toggle between Show Formula/Normal Mode in whole worksheet (Toggle Key) | [Ctrl] + [`] |
| Close Current Workbook | [Ctrl] + [w] |
| Copy Contents of Cell to Left | [Ctrl] + [R] |
| Create Table and set filters | [Ctrl] + [L] Or [Ctrl] + [T] |
| Insert Hyperlink Dialog | [Ctrl] + [K] |
| Current Date | [Ctrl] + [;] |
| Current Time | [Ctrl] + [:] |
| Copy Contents of Cell above current selection | [Ctrl] + ['] |
| New Workbook | [Ctrl] + [N] |
| Delete Selected Cell | [Ctrl] + [-] |
| Insert Blank Cell | [Ctrl] + [=] |
| Auto Sum | Alt + [=] |
| Complete Formula with parenthesis and parameters | [Ctrl] + [Shift] + [A] |
| Toggle between open workbooks | [Ctrl] + [TAB] |
| Open Worksheet to left of current worksheet | [Ctrl] + [PgUP] |
| Open Worksheet to right of current worksheet | [Ctrl] + [PgDn] |
| Box the Current Selection | [Ctrl] + [Shift] + [7] or [Ctrl] + [&] |
I hope you found the information useful and Thank you for reading.
