Selecting Contiguous Data
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!
Get answers right away at our AE Excel Support Forums!
Leave a comment
| Trackback


