1
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?
student
Posted 2011-03-11T18:57:23.567
Reputation: 455
0
One possibility is to press F2.
student
Posted 2011-03-11T18:57:23.567
Reputation: 455
1
Go to tools / options / open office.org 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.
BrianA
Posted 2011-03-11T18:57:23.567
Reputation: 1 514
1
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)
surr3a1
Posted 2011-03-11T18:57:23.567
Reputation: 11