There are several navigational shortcuts that can help one expedite the work by allowing quick Navigation within worksheet and across worksheets/workbook in Microsoft Excel. Below tables lists such know short-cuts. Some shortcuts are likely to be specific to a particular version of Microsoft Excel and however, in general should be applicable to all.
| Task / Objective | Shortcut / Key Sequence |
| Jump to Cell A1 | [Ctrl]+[Home] |
| Jump to the last cell in the worksheet that contains Data. | [Ctrl]+[End] |
| Jump to Next Sheet (To the right of current sheet) | [Ctrl]+[PgDn] |
| Jump to Previous Sheet (To the left of current sheet) | [Ctrl]+[PgUp] |
| Go To a Cell | [F5] |
| Toggle between open workbooks. More than one workbook (excel file) must be open | Ctrl + TAB |
| Hide Column | [Ctrl] + [0] |
| Unhide Column | [Ctrl] + [Shift] + [0] |
| Hide Row | [Ctrl] + [9] |
| Unhide Row | [Ctrl] + [Shift + [9] |
| Show/Hide Chart | [Ctrl] + [6] |
| Select Multiple Cells (Hold [Ctrl] key while clicking cell. You can click random cells in the worksheet.) | [Ctrl] + [Click] |
| Select Range of Cells (Hold Shift Key while selecting cells to select a range) | [Shift] + [Click] or [Shift] + {Arrow Keys} |
| Select current data block (cell containing data including and adjacent to current selection) | [Ctrl] + [*] or [Ctrl] + [Shift] + [8] |
I hope you found the information useful and Thank you for reading.
Posted in
Auto Complete,
Excel,
Excel 2003,
Excel 2007,
Excel 2010,
Excel Functions,
Grouping Sheets,
MS Excel,
MS Power Point,
MS Word,
Row Column,
Secret,
shortcuts,
Tips,
Word 2007,
workbook,
Worksheet
+ 
= System Properties dialog box
In order to find out details about RAM, OS, Processor speed we all have been doing below set of steps…
- Minimize All Application Window to view Desktop
- Right Click on My Computer
- Left Click on Properties in the context sensitive menu.
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.
Posted in
Break,
Control Panel,
Pause,
Secret,
shortcuts,
System,
Tips,
Tricks,
Win Key
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.
Posted in
Auto Complete,
Excel,
Excel 2003,
Excel 2007,
Excel 2010,
Excel Functions,
Grouping Sheets,
MS Excel,
MS Power Point,
MS Word,
Scanpst.exe,
Secret,
shortcuts,
System,
Tips,
Tricks,
workbook,
Worksheet
