In LibreOffice Calc is there a hotkey to edit the current cell?

Question

I am wanting to edit a column of cells (for example, copy/pasted values have $0.005/hr and I want them to just be 0.005)

I can navigate with arrow keys, I can click to edit the existing value, but would much rather edit the existing value without the use of a mouse.

As it is I have to move my hand to and from the mouse to click the cell for each edit.

score 20 · Accepted Answer · edited Aug 13 '15 at 01:49

20

F2, Same as in Microsoft Excel.

Once done you can press Enter to switch to next row.

edited Aug 13 '15 at 01:49

Tracker1

answered Aug 13 '15 at 01:05

user70926

score 4 · Answer 2 · answered Jun 15 '23 at 12:11

If you prefer to use the input line rather than the cell contents editor, use:

Shift+Ctrl+F2

Moves the cursor to the Input line where you can enter a formula for the current cell.

If you wish to reassign the shortcut key associated with this command:

2 Answers2