Excel for Data Analysis and Visualization

Selecting ranges with mouse and arrow keys- short cuts

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop