0

This question already has an answer here:

In Google Sheets, pressing the Enter key moves the cursor down a cell. For example:

  1. position cursor on the cell
  2. type to enter text
  3. press Enter key
    • Expect: Cursor stays on the cell I was just editing
    • Actual: Cursor moves down to next row

Is there any way to turn off this behaviour in Google Sheets so the Enter key doesn't move the cursor? In Excel, there's a setting to choose what happens when the Enter key is pressed (to control if it moves to another cell or not).

marked as duplicate by Rubén, serenesat, jonsca Jun 16 at 0:46

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Since you're probably not editing the same cell twice, it may help that you can "submit and move" not just down, but in any direction. Enter moves down, and Shift-Enter moves up. Tab moves right, and Shift-Tab moves Left. – Joel Reid May 16 at 15:55
0

No, there is no such option in Google Sheets. Pressing Enter key will always result in moving the cell selection by one cell downwards. As for the mouse cursor - it stays where left.

Your only option is to use the 3rd-party tool (AutoHotKey for example) which will "fix" this behaviour like for example:

  1. detect that active window is Google sheet
  2. upon pressing Enter key script will detect it and auto-press Arrow Up key

Not the answer you're looking for? Browse other questions tagged or ask your own question.