Actually, that behavior changes depending on what's in the activecell and what's
immediately below the activecell.
For example, I have this stuff in A1
6
(And cells that look blank are really empty cells!)
A B C D
1 asdf asdf
2 asdf asdf
3 asdf asdf
4 asdf asdf
5 asdf asdf
6 asdf asdf
Hitting End, followed by down arrow does:
Activecell Takes me to
A1 A2
B1 B3
C1 C3
D1 D4
My guess (and it's a complete guess) is that the cells you see that look blank
aren't really empty.
Either they contain formulas that evaluate to "" (or even space characters " ")
Or
they used to contain formulas like this and have been converted to values.
You can clean up the detritus left over from converting formulas that evaluated
to "" and making the cells really empty by this technique:
Select the range to fix
edit|replace
what: (Leave blank)
with: $$$$$
replace all
and reversing it
edit|replace
what: $$$$$
with: (Leave blank)
replace all