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.
No comments:
Post a Comment