Selecting ranges with mouse and arrow keys- short cuts
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.
OR, highlight a large area (without clicking the mouse and then holding it while you scroll all the way down).
Working with the arrow keys
If you use the arrow keys there are some useful helper keys to:
Highlight a number of cells,
Jump to the end of a range (where the last cell with something in it is):
or quickly highlight a range with your arrow keys:
To see the full course contents click here.