next empty cell

[Guest]

On my PC at home, when I strike the "end" key then the down arrow key, the
cursor goes to the last cell with data in that column (Excel 2000)
On my work PC key the cursor goes to cell O47. (Excel 2003)
How do I get my work PC to behave like my home PC?

 

[Dave Peterson]

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 A16
(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