Ask Your Question
0

Calc : How to edit formulae in formula bar directly

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

jan703 gravatar image

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

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
0

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

JohnSUN gravatar image

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

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.

SetHotKey.png

edit flag offensive delete link more

Comments

Thanks for your answer - it works as expected.

jan703 gravatar imagejan703 ( 2018-12-29 10:55:03 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 34 times

Last updated: Dec 29 '18