ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel problem, Enter key (https://www.excelbanter.com/excel-discussion-misc-queries/184586-excel-problem-enter-key.html)

funkev123

Excel problem, Enter key
 
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 ?

Brad

Excel problem, Enter key
 
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....

"funkev123" wrote:

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 ?


AKphidelt

Excel problem, Enter key
 
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.

"funkev123" wrote:

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 ?


funkev123

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

"akphidelt" wrote:

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.

"funkev123" wrote:

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 ?


AKphidelt

Excel problem, Enter key
 
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.

"funkev123" wrote:

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

"akphidelt" wrote:

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.

"funkev123" wrote:

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 ?



All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com