Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In OpenOffice Calc, when I type in a cell, the program can sometimes autocomplete the information from earlier rows in the same column. I can hit Enter to accept the completion and move to the next row. How can I accept the current completion but stay in the same cell, with my cursor behind the word that was autocompleted?

share|improve this question

Go to tools / options / open Calc / general :under 'input settings' uncheck "Press enter to move selection"

Not one of their better wording examples I fear: "move selection" really means "move the cursor to a new cell", and there are options as to which way it moves.

share|improve this answer
up vote 0 down vote accepted

One possibility is to press F2.

share|improve this answer

In google sheets and excel you can press End to auto complete and still remain in the same cell (I've been looking for this one for a very long time and noone knew. Then I found it by accident)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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