From the menu bar, Tools Options, click the Edit tab and check the 'Move
selection after enter' box, then use the drop-down to choose which direction
to move.
--Bruce

"Hollywood" wrote:

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?