Numbers for Mac - active cell moves down after "Enter"

Many former Excel users like me are used to the active cell remaining where it is after data entry. While the Excel default is set to move the active cell down 1 row when Enter is pressed, this is actually a setting that can be changed within Excel Preferences.

Unfortunately, Numbers does not offer this option so the active cell moves down a row when the Enter buttons pressed after data entry. If I wanted the active cell to move down a row, I could press the down arrow instead off Enter. So the ONLY thing Numbers makes IMPOSSIBLE is to have the active cell remain in the same position after data entry. This is driving me crazy - so crazy that I've stopped using Numbers and purchased Excel. My wallet is lighter but I'm far more content.


iMac 27", macOS 10.12

Posted on Jan 10, 2020 11:42 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 11, 2020 7:52 AM

Select destination cell:



Type a number:


hold <command> then type <Enter>:



release <command> key


cell B4 was selected and active at beginning and is still selected now

5 replies

Jan 11, 2020 7:35 AM in response to Wayne Contello

Can you pls explain further? If I enter data in a cell and hold <Command> while hitting <ENTER>, the cell remains active and the cursor moves to the next line. Am I misunderstanding your instructions?


What I'm looking for is a way to enter data in a cell and NOT have Numbers moved down to the next row - trying to get Numbers to say on the cell where I've just entered the data.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers for Mac - active cell moves down after "Enter"

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.