Selecting Contiguous Data

November 2nd, 2004 | Categories: Shortcuts | Tags:
-->

Here’s a shortcut that speeds up selecting contiguous data.

ShortCut:
Control + Shift + ArrowKey

For instance, you want to select every cell in Column A that has data in it, and assuming there are no empty cells in the column:

1. Click the first Cell (A1) in Column A to make it active.
2. Hold Control, Hold Shift, and click the Down Arrow

It will select all your data in Column A and even quits your selection where the data ends.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
No comments yet.