A non-contiguous list is a list with occasional blank cells and that makes it harder to select the entire cell range.
The picture above shows a part of a list that has 3000 values with occasional blanks. How do we quickly select the entire list?
The first thing that comes to mind is selecting this list using CTRL + SHIFT + DOWN ARROW but as you might know, the selection stops at every blank cell.
Here is how to select the entire list:
- Select cell B2
- Press CTRL + SHIFT + END
You have now selected the entire non-contiguous list.
If you record a macro while pressing CTRL + SHIFT + END you get the following code:
Make sure you select the first value in the column before you run the macro.
Download Excel *.xlsm file
Select a non contiguous range.xlsm