I’ve become accustomed to using keyboard shortcuts to move quickly in spreadsheets.
One of the most common functions in Excel is the ability to toggle between Edit Cell and Select Cell/Cell Point using the F2 function key.
- Enter 2 into cell A1, 3 into cell
A2, and 1 into cell A3 (for calculation in following
- Select cell B2 using the
mouse or keys.
- Click F2 to enter edit mode in B2.
- Type =A1+A2.
- Hit enter, and the result should be 5.
- Click F2 to enter edit.
- Now imagine you would like to add cell A3. You click the “+” button and attempt to move the cursor to cell A3 with the keys. However, the cursor remains in the cell. In Excel, you could hit F2 again, which would allow the arrow keys to leave the cell being edited. I cannot do so in LibreOffice Calc.
I’m using 184.108.40.206 on MacOS Big Sur.
Is there a way to do this that I’m missing?