Forum Discussion
Enter key not behaving as expected
Hi
I have a Microsoft 365 subscription, recently upgraded old windows laptop for an all singing all dancing new MacBook Pro. Downloaded the apps and away I went. Everything is going okay except in Excel when I enter a formula and hit 'enter' nothing happens. The formula is still active ie if I click away into another cell it thinks I'm trying to include that in the formula- I can't figure out why this is happening. If I try to enter the formula in the formula box a similar thing happens but this time instead of entering the formula as expected the cursor moves to the start of the formula. In either the cell or formula box I cannot edit the formula without highlighting and editing the whole thing- it simply moves the cursor to the beginning of the formula.
It's driving me mad! Any help or advice greatly appreciated.
Many thank
7 Replies
- Is your column formatted as text if so try changing it to Number or General
Thank you for the tip, Tanya Denton, however the column is formatted as General already. When I type and press enter, instead of adding what I type to the cell and move on to next, it drops down autofill list to select an item close to what I type.
I have the same problem. MrsXmas did you find the solution for this?
Select Preferences from the Excel menu.
Go to Edit.
Make sure that the check box "After pressing Return, move selection" is ticked.
Thanks. I'm afraid I don't know what causes the problem then.
