While using a mouse is easy – it is also very slow. Moving from cell to cell and clicking/double-clicking is a surefire way to keep your workflow slow.
To speed yourself up, get use to using your keyboard exclusively when you are working with spreadsheets. More importantly play with the following commands and use them to quickly navigate to, highlight, or edit a cell.
1) Your arrow keys will move your cursor to the next cell in any direction you choose:
← left arrow
↑ up arrow
→ right arrow
↓ down arrow
2) Shift + arrow:
This command will highlight your current cell and the subsequent cell you choose (based on your arrow direction). Continue to hold shift and select different directions to select multiple cells horizontally and vertically.
3) Ctrl (Command for Mac users) + arrow
This combination will move your cursor immediately to the next blank cell in a column or row. So if you have 100 rows of data and want to instantly move to the bottom, use this command for lightning fast navigation!
Use combinations of the above to move quickly and highlight the data you want. See the video below to see how combining arrow keys, shift, and ctrl/command keys can help you move and select information quickly.