Excel

Occasional Visitor

How do I find Excel option so after typing entry it doesn't move to next cell on return?

1 Reply

@Liz_Simms 

Excel for Windows:

  • Select File > Options.
  • Select Advance in the navigation pane on the left hand side.
  • In the 'Editing options' section, clear the check box 'After pressing Enter, move selection'.
  • Click OK.

 

Excel for Mac:

  • From the top menu bar, select Excel > Preferences.
  • Select Edit.
  • In the 'Editing options' section, clear the check box 'After pressing Enter, move selection'.