Navigating empty cells

[MRomanow]

Anyone know a shortcut to navigate empty cells in a column?

I want to go all the way to the last filled in cell in the row by using SHIFT-END-Down Arrow but it stops at all the blank cells.

a
b

d
e

f

I want to go all the way to F and skip in between B-D and E-F.

 

[dtchan]

Depending whether you want to highlight the cells or not.
Not highlight --> ctrl end
Highlight --> hold down shift, ctrl end

 

[MRomanow]

That only works correctly if I have just 1 column of data. With many rows it takes me to the end of the last column and highlights it all.

Any suggestions? Thanks