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

 

[VBAProIWish]

Thanks Fazza, but neither will work.

CTRL+SHIFT+UP
I will have a different number of blanks, then non blank cell in this column every time I run the report, so CTRL+SHIFT+UP several times won't work as I won't know the number of times it's needed each time I run the report.


CTRL-SHIFT-HOME
Won't work because I need to select a specific column and doing it this way will select a region of columns.

But thanks anyway

 

[RoryA]

CTRL+SHIFT+UP several times won't work as I won't know the number of times it's needed each time I run the report.

Are you trying to automate this? If not, then you just hold those three keys down until you hit the top; if you are automating it, then the whole thing is moot anyway.

A relatively quick way, if you have no data underneath the selection, would be:
Ctrl+Spacebar (select column)
Ctrl+. (activate top cell)
Ctrl+Shift+Up arrow (shrink the selection to the last used cell)

 

[djl0525]

CTRL+. That's a new one on me! I'm gonna have to use that!

Thanks! -- DJ

 

[VBAProIWish]

Yes, I am trying to automate it. I found a change in the code itself, so I guess I don't need this shortcut, but I suppose it would be nice to know it, if there is one.

Thanks anyway to everyone!