Select 15,000 rows that has some data and some blanks

[storkhiw]

I have data starting in cell C5 and going down to cell C15000. Some of the cells have data and other cells are blank. I want to be able to select all 15,000 cells without having to hit the ctrl+shift+down arrow or ctrl+shift+pg down 1,000 times. Is there a way to select all the rows NOT using ctrl+space bar?

In cells D5 - D15000 I have data where every cell is filled, wondering if I could select D5 - D15000 with the ctrl+shift+down arrow and then move the selection over to C5 - C15000 while not keeping D5-D15000 selected?

I could not find a post like this so any help would be appreciated or if the question has already been answered if you could point me to the thread that would be greatly appreciated.

Thanks

[sktneer]

Hi,
Welcome to the Forum.

In the Name Box (just above the column A), type D5:D15000 and hit Enter.
Alternatively you may press Ctrl+G to open Go To window and in the reference box type D5:D15000 and click OK.

Both the method will select the range D5:D15000.