All articles with 'select' Tag

Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]

Published on Dec 30, 2008 in Learn Excel
Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]

Here is a very quick spreadcheat for the new year.

If you need to select all the cells in a series (either row-wise or or in columns) you can use one of these 2 shortcuts (and avoid unnecessary scrolling)

1. Select the first cell in the series

2. Press Shift + Ctrl + Down arrow

Or

1. Select the first cell in the series

2. Hold down SHIFT and Double click on the edge of cell in the direction you want to select

Continue »