End+Down goes down one and RIGHT one ?!

[zorgkang]

Hello!

My boss is having a problem in Excel. On her computer, the shortcu
END+DOWN doesn't work normally, it moves the focus only one cell dow
and also one cell right. I haven't tested it much (since it's on he
computer), but I haven't found any info on the web that would explai
this behavior.

Does anybody know what's going on?

Thanks!
Mar

 

[Dave Peterson]

End-Down works by knowing what's in those cells below the selected cell.

If I'm in a range of cells that is non-empty, then it takes me to the last
non-blank cell in that range.

If I'm in a range of cells this is empty, then it takes me to the next non-blank
cell.

If I'm in a cell that's empty, and the cell directly below is non-blank, it
takes me to that cell directly below.

If I'm in a cell that's non-empty and the cell directly below is empty, it takes
me to the next non-blank cell.

If that doesn't help, you may want to post back with more details--and remember
even though you have formulas that evaluate to "" (looks empty), these aren't
empty cells.