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

VBA word change keys 0
Cell data entering slow! 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Merging from an Excel file with graphics 1
Excel Bug 0
change direction active cell indicator moves when enter key is pre 2
Excel does not accept text format! 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top