0

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!

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

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.

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?

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?

  • Use filters, then select all? – Saulysw Jul 11 '15 at 5:01
  • @Saulysw err... could you elaborate on that? – MercWithMouth Jul 11 '15 at 5:11
  • Sorry I re-read your question. To do this quickly I would select the first cell, press the CTRL-SHIFT-END key, which should take you to the last cell and select them all. – Saulysw Jul 11 '15 at 5:32
  • Of course you can also select the first cell in a range, use the scroll bar to go to the bottom, then press SHIFT when you select the last cell. This will select a range too. – Saulysw Jul 11 '15 at 5:38
  • Mmmm. control+shift+end will select EVERYTHING that has data in it including from the adjacent columns. And using the scroll-bar... well, that's kind of what I'm trying to avoid. – MercWithMouth Jul 11 '15 at 6:04
0

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!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.