Keyboard shortcut to highlight all cells in a column from bottom to top

[VBAProIWish]

Hello,

What is the best way to highlight all cells in a column from bottom to top?

For example, if I'm in column O, row 138, what keyboard shortcut would I need to select ONLY and ALL cells from the row I'm currently on, (in this example, 138) to row 1 and ONLY in that particular column?

Keep in mind that the next time I may be starting at row 1,200, it could be different everytime.

I tried everything I could think of..

CTRL+A
CTRL+SHIFT+A
CTRL+HOME
CTRL+SHIFT+HOME
CTRL+UP ARROW
CTRL+SHIFT+UP ARROW
CTRL+PAGE UP
CTRL+SHIFT+PAGE UP

and nothing worked to select everything in that column from the row I'm currently on, to row 1.

Regards

 

[VoG]

Try Shift + CTRL + Up arrow.

 

[sous2817]

Shift + Page Up seemed to work for me...

 

[VBAProIWish]

They only work if you have data in every cell in the column. I need it to highlight ALL cells within the column and some cells are blank, some are not, then some are blank, etc.

The 2 shortcut methods above only work if the data is contigious

thanks anyway

 

[djl0525]

Did you try CTRL + space?

DJ

 

[VoG]

Try Shift + Page Up.

 

[VBAProIWish]

Thanks guys but...

CTRL+SPACE didn't work

SHIFT+PAGEUP didn't work

I think it's the sporatic blank cells throughout the column that are causing me grief

Anymore thoughts?

 

[Seti]

This is pretty keyboard intensive, but if you are in O138 for example, try this combo:

F8 to extend the selection, then F5 to GOTO and then type in O1 followed by F8 to stop the estend selection option.

 

[VBAProIWish]

Seti,

I thought it worked but I tried it again, but this time, I removed several rows, and "BLANK2" show up below the last row of data equal to the amount of rows I deleted. I posted this question but it appears it might be too difficult, so I figured I would try another approach that might be a bit simpler

http://www.mrexcel.com/forum/showthread.php?t=400991


Basically, what I'm trying to do is to replace all blank cells in my "Earth" column with "BLANK2", but NOT the whole column, I want it to stop when it's equal to the bottom-most row of data in a column named "Galaxy".

So, from the "Galaxy" column, I started at row 1 and used CTRL+SHIFT+DOWN ARROW to select the last cell with data.
The only problem at this point is that the whole data column is selected, which is no good for me because I only want the last CELL to be highlighted.

To compensate for that, I had to figure out a way to select JUST the last data cell and the only thing that worked for me was this...

With all the data cells in the "Galaxy" column highlighted and the focus on the last data cell..
I used CTRL+SHIFT+PAGE DOWN to select the first blank cell below the last data cell, then used arrow up to select the last cell with data in the "Galaxy" column, this allowed me to select ONLY the bottom-most data cell in the "Galaxy" column.

At this point, I just arrowed right to the "Earth" column and...here's where I'm stuck.
There appears to be no way to highlight ALL cells in that column only up to the top from that point (including blank cells).

Regards

 

[Fazza]

I think the best standard (you could create your own custom one in VBA) shortcut key choices are,

CTRL-SHIFT-UP, and hold the UP arrow until it gets to the top. It will skip along block to block.

Or,
CTRL-SHIFT-HOME, and then whilst holding SHIFT, repeatedly hit right arrow.

HTH, Fazza