How can I quickly select cell ranges in Excel?
23 September 2014
While you can use the mouse to select the cells containing the data you want to analyse with statistiXL it is often quicker to use keyboard shortcuts instead. Here are some of the combinations you can use.
Press | To |
---|---|
CTRL+A | Select the entire worksheet |
CTRL+SPACEBAR | Select the entire column |
SHIFT+SPACEBAR | Select the entire row |
F8 | Turn on extending a selection by using the arrow keys |
CTRL+SHIFT+END | Extend the selection to the last used cell on the worksheet (lower-right corner) |
CTRL+SHIFT+HOME | Extend the selection to the beginning of the worksheet |
CTRL+SHIFT+arrow key | Extend the selection to the last nonblank cell in the same column or row as the active cell |
SHIFT+F8 | Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range |