Excel problem, Enter key

F

funkev123

when I type something into a cell generally when I press enter key it will
move down to the next cell, somehow this has stopped working I'm sure I press
something accidently could somone help ?
 
B

Brad

If you are working in 2007 - click on the pearl - upper left corner.

click on Excel options (next to exit Excel)

click on Advanced

Uncheck mark the first editing options.....

HTH....
 
A

akphidelt

Try going to Tools-->Options-->Edit and check to see if the checkbox that has
"Move Selection after Enter" is checked.

If thats not it then Im afraid I don't know what else it can be.
 
F

funkev123

excellent, thank you! it's back to working order now I don't know how I
unchecked that box in the first place...
 
A

akphidelt

lol, that is interesting, especially if you haven't been in the options in
the first place. Maybe there is some weird shortcut key combination that
disables, but im pretty sure there isn't.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change direction active cell indicator moves when enter key is pre 2
Excel 2007 Problem Paste/Enter Key 0
XL2007: Down <> down on Enter? 3
Enter key 2
enter 2
Get excel to automatically go to the next cell w/o pressing enter 1
In Excel, when i key in 02352 and press enter, the zero goes off 1
Number automatically divided by 100, why? 4

Top