I am an MS Excel user who is just starting in Calc.
Many times I want to edit a cell but do not want the cursor to move after completing the edit. I want the cursor to stay in the cell I just finished editing since I want to see the effect of the edit and, as needed, edit again.
In Excel I can accomplish this by CTRL+ENTER.
However, CTRL+ENTER, in Calc, creates a second line in the cell I am editing.
Is there a way to accomplish the Excel equivalent of CTRL+ENTER (i.e. complete the editing and stay in the same cell)?
Alt+Enter
1 Like
I don’t find where/if it is documented [see @erAck comment below].
For “no formula” cell content, I use F9.
When I need to change the value of one cell (again and again), I use cells in column A*. This way I can press Left Arrow, or Home, or Shift+Tab, and stay in the same cell.
*Or use cells in row 1, and press Up Arrow, or Shift+Enter.
It’s a side effect of “fill a selected cell range”; if no cell range was selected then the current cell is implicitly selected and within a selection the current cell stays current after input. See first sentence on Shortcut Keys for Spreadsheets “To fill a selected cell range with the formula that you entered on the Input line, press Alt+Enter.” Works with any input though, not only formulas in the Input Line…
1 Like
But this changes the cell number format to Number - Standard (tdf#165217)
You can disable the first point under
>Tools>Options>LibreOffice Calc>General>>>Input Settings .
1 Like
Thanks to LeroyG for the workaround.
The workaround leaves the other default actions as-is but resolves this specific issue.
On macOS with an Apple keyboard, the keyboard combinations
- alt + enter keeps me stuck in the same cell,
- shift + enter moves the activity up one cell,
- enter solo moves it down one cell, and
- cmd + enter inserts another entry with a line break – Unicode(10), “\n”, newline – in the same cell.
2 Likes