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. We need to find a quicker way to select this list.
Let us assume you have cell A1 selected.
I suggest you try:
- Press RIGHT ARROW
This will take you to the first blank column. In this example column B. (Cell B1)
- Press CTRL + DOWN ARROW
This will take you to the last row on column B. Cell B1048576 (Excel 2007)
- Press LEFT ARROW
This will take you back to column A. Cell A1048576 (Excel 2007)
- Press CTRL + UP ARROW
This will take you to the last not blank row in list
- Press CTRL+SHIFT+HOME
- Optional: Adjust selection. SHIFT + ARROW KEYS
You have now selected the entire non contiguous list.
Do you know a quicker way to select a large non contiguous list?