Pressing ENTER

[Jenna]

Hi

I'm using Excel Xp.
Normally whenever I'm finishing entering my data into a
cell, I press 'ENTER' and it'll move to the cell below it,
which I like. However, now when I'm finished entering my
data and press 'ENTER' it just stays highlighted in the
same cell I am in and I don't like it. It's very
annoying.
For example, normally I would enter my data in cell A2 and
press enter, moves down to the next cell - A3. But now, I
enter data into cell A2, press enter...stays in the same
cell A2.

How would I fix this??

Thanks a lot

 

[Norman Harker]

Hi Jenna!

No need to post to more than one group:

Use:

Tools > Options > Edit
Check "Move selection after Enter"
Select Down from drop down
OK
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.