How does the user make a selection in MSExcel that contains only those cells that contain data?

Question

Got an MSExcel question for you.

he specs for my computer are: Intel Inspiron laptop i3-2.20ghz , 8GB DDR3, 400GB HDD, Win 7 Prem.

And the version I am using is MSExcel 2003.

My question has to do with how to make a selection containing multiple cells. Ordinarily, all you do is left click the first cell you want in the selection, and then drag the mouse over to the last cell you want in the selection.

But, there are times when you don't want to make a selection containing just a few dozen cells, or fewer.

Rather, you want to make a selection containing hundreds or even THOUSANDS of cells.

Traditionally, the recommended technique was to simply click the 'column heading' (or 'row heading') pertaining to all the cells you want to be in the selection.

However, this would mean selecting some 63,000+ cells, which makes it less useful in certain situations where you only want the selection to consist of cells that contain data.

So, how would I do it?

How would I make a selection in MSExcel that contains only those several thousand cells that contain data, but not the cells afterward which do not contain data?

Thanks in advance!

PICTURE1 Here, the first column -- and most of the other columns -- contain thousands of cells that contain data.

PICTURE2 By simply clicking the 'column heading' marked 'A', the user makes a selection of all 63,000+ cells in the column, not just the cells which contain data.

PICTURE3 In this instance, the several thousand cells in the first column that contained data are selected-- this was done MANUALLY. Ergo, the question: how does the user make a selection in MSExcel that contains only those several thousand cells that contain data, but not the cells afterward which do not contain data?

Answer 1

I think I figured it out, I came across this by chance.

1. Alright, so with the cursor being in the cell at the very top of the selection, press END once. (do NOT hold it down)

2. Then, press and hold SHIFT.

3. Now, with SHIFT held down, press DOWN.

This technique makes little sense -- after all, who would think to press the END button once before pressing another combination of keys?

But IT WORKED!