<Tools <Options <Edit tab,

Check "Move Selection After Enter",
And choose direction.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Hollywood" wrote in message
...
This is going to sound terribly dumb, but I used to be able to press the
"enter" key and the next cell in the column would become the active one.
Randomly however this ceased to happen. Can anyone please advise as to how
I
can re-activate this option?