I would normally just hit Enter in other spreadsheet applications. Hitting Enter while in a cell in Calc moves me to the cell below.
Using the mouse to click on a cell is such a chore if you are editing hundreds of cells.
This can be set up under Tools → Customize. Select Functions → Internal → Toggle Edit Mode in the lower pane; the Enter key (symbolized as “
”) (or to any other key/combo, if you wish) from the upper pane; click Modify.
Thanks! That worked for me.
LibreOffice should change the default key for Toggle Edit Mode from F2 to other keys in their Mac versions of Calc. F2 in Mac is for brighting up your screen.
This also works on Linux, though Enter is listed as “Return”, not “”. Also, this is all on the “Keyboard” tab of the Tools → Customize dialog.
One minor nit: If you start entering text into a cell just by typing (ie: without pressing anything Enter), pressing Enter acts weird with this setting. You have to press Enter twice to stop editing the cell. Seems like a bug.
In May of 2017 on a Mac you can find this option using cmd-, then look for the LibreOffice Calc section and General. There are checkboxes for “Press Enter to move selection” and “Press Enter to switch to edit mode”.
1 Like