Ask Your Question

Calc : How to edit formulae in formula bar directly

asked 2018-12-29 01:40:13 +0200

jan703 gravatar image

updated 2018-12-29 01:42:06 +0200

Possible duplicate of edit directly in cell.

To edit a cell formula, I move the cursor to the cell and then press F2. I can then edit the formula in the cell. I find this cumbersome for long / complex formulae and editing directly in the formula bar is a lot simpler for me.

My question : Is there a setting to force editing in the formula bar, rather than than in-cell, on F2 keypress?

(I know that I can click the formula wizard and edit long formulae there, but that's not what I'm after)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-29 10:48:18 +0200

JohnSUN gravatar image

updated 2018-12-29 10:48:59 +0200

You can easily do this. Since F2 is the key for editing the cell, and Ctrl+F2 is the hotkey for invoking the Function Wizard, it seems to me that the Alt+F2 key combination is best for editing in the Formula Bar. This is my opinion, you can choose any other of the available key combinations.


edit flag offensive delete link more


Thanks for your answer - it works as expected.

jan703 gravatar imagejan703 ( 2018-12-29 10:55:03 +0200 )edit

This is a great find! Since I never like to edit directly in the cell, I just replaced the F2 assignment from "Cell Edit Mode" to "Input Line". It's the (circuitous) equivalent of turning off Excel's "Allow editing directly in cells" option. Thanks!

Bitstream gravatar imageBitstream ( 2019-06-22 18:13:16 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-29 01:40:13 +0200

Seen: 134 times

Last updated: Dec 29 '18