Here is a picture of a non contigous list in excel. The list has 3000 rows 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. We need to find a quicker way to select this list.

Let us assume you have cell A1 selected.

I suggest you try:

  1. Press RIGHT ARROW
    This will take you to the first blank column. In this example column B. (Cell B1)
  2. Press CTRL + DOWN ARROW
    This will take you to the last row on column B. Cell B1048576 (Excel 2007)
  3. Press LEFT ARROW
    This will take you back to column A. Cell A1048576 (Excel 2007)
  4. Press CTRL + UP ARROW
    This will take you to the last not blank row in list
  5. Press CTRL+SHIFT+HOME
  6. 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?