Hi. I hope someone can help with this:
Cell A1 is used for input. Other cells use that input for subsequent calculations. This is a repetitive routine.
How do I make the cursor automatically return to A1 after pressing “enter” so that I can then insert the next data item into that cell?
Many thanks,
ilsm
Try Alt+Enter. It has a side effect of also selecting the cell, but still may be OK for the use case.
Also can accept the input pressing Arrow Up (works for all cells in row 1) or Arrow Left (works for all cells in column A).
Many thanks
Thanks, both
Options|Calc|General; uncheck [ ] Press Enter to move selection.