Scroll wheels are nice but they can’t compare to keyboard shortcuts when navigating and selecting sections in large Excel worksheets and tables. Here are a few favourites:
Navigating
1. Ctrl-Home – jumps to upper left cell, A1
2. Ctrl-End – jumps to lower right cell containing a value
3. Ctrl-Arrow Up/Down/Left/Right – jumps to extreme edge of a column or row before an empty cell. (i.e. if you have blank cells in the middle of your table, the navigation will stop. If you wish to continue to the next area, keep holding the ctrl key and hit the arrow again.)
Selecting (for copying or formatting)
Add Shift-key to above short-cuts
1. Shift-Ctrl-Home – select everything above and to the left of the selected cell.
2. Shift-Ctrl-End – select everything below and to the right of the selected cell.
3. Shift-Ctrl-Arrow Up/Down/Left/Right – select everything to the edge of the column or row (before an empty cell).
Try this example on one of your files or, use the sample file in the attachment.
Example: 2-Ways to Select an entire table
Go to top left cell in your table.
1. Shift-Ctrl-Down Arrow then, while holding the Shift-Ctrl, hit the Right arrow.
or
2. Shift-Ctrl-End then, while holding Shift (releasing Ctrl), hit the Left arrow (to de-select the blank column).
Be sure to subscribe to this topic for updates and reply with some of your favourite keyboard shortcuts!
Attachments:
You must be
logged in to view attached files.
