Skip to content

Frequently Asked Questions

How can I quickly select cell ranges in Excel?

23 September 2014

by Alan Roberts

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
Read more posts from the category.