Enter key not behaving as expected

[MrsXmas]

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 

[#2]

@MrsXmas 

Select Preferences from the Excel menu.

Go to Edit.

Make sure that the check box "After pressing Return, move selection" is ticked.

[#3]

@HansVogelaar 

Hi 

Thanks for your reply. I have checked and it is already ticked. Thanks again 

[#4]

@MrsXmas 

Thanks. I'm afraid I don't know what causes the problem then.

[#5]

Thanks for your help 🙂

[#6]

I have the same problem. @MrsXmas did you find the solution for this?

[#7]

Is your column formatted as text if so try changing it to Number or General

[#8]

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.