Selecting ranges with mouse and arrow keys- short cuts

Please purchase the course before starting the lesson.

You may find it useful to learn some of the quick ways to get around your spreadsheet. Whether you use your mouse/ trackpad or the arrow keys, by combining them with CTRL and SHIFT you can do things faster.

Working with a mouse/ trackpad

You can activate cells that are not next to each other.

selecting ranges

OR, highlight a large area (without clicking the mouse and then holding it while you scroll all the way down).

selecting ranges

Working with the arrow keys

If you use the arrow keys there are some useful helper keys to:

Highlight a number of cells,

selecting ranges

Jump to the end of a range (where the last cell with something in it is):

selecting ranges

or quickly highlight a range with your arrow keys:

selecting ranges

To see the full course contents click here.

Back to: Intermediate Excel Course > Tips and Tricks- Intermediate