Ask Your Question

edit directly in cell

asked 2017-02-02 02:39:05 +0200

Exceluser gravatar image

updated 2020-08-31 19:14:28 +0200

Alex Kemp gravatar image

Microsoft has an option, which can be disabled, called "enable edit directly in cell".

It's great, because when disabled, a long formula in a cell ONLY shows up in the formula bar, where it should be, and it doesn't show the formula in the cell in the spreadsheet.

Case in point: I wish to change (type edit the formula in) say, cell D11, but in order to know what to type, I need to be able to see -with my human eyes- the value in C11. D11 has a long formula which covers up C11. It's another simple, clunky shortcoming.

Does this option actually exist in LIbreoffice?

edit retag flag offensive close merge delete


At the moment the full formula is displayed in the cell even if I highlight the cell and click in the formula bar. I can probably live with what the OP describes if at least I can see all my cells if click in the formula bar. Can that be done?

pateksan gravatar imagepateksan ( 2019-11-27 11:17:24 +0200 )edit

The keyboard combination to edit in the formula bar is Ctrl+Shift+F2. this setting can be changed via Tools/Customize/Keyboard. it is needed to select the line showing F2 Cell edit mode and enter "Input line" in the field function, confirm by selecting Modify and then Save.

fede gravatar imagefede ( 2021-03-04 21:51:31 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2017-02-02 07:51:02 +0200

pierre-yves samyn gravatar image


To my knowledge there is no option for that. In a case such as this one I use the Function Wizard that allows to modify (each term of) the formula without masking the surrounding cells.



edit flag offensive delete link more

answered 2017-10-21 14:39:05 +0200

Thelma gravatar image

Just move the cursor to the cell and press F2. This feature is available in Libre

edit flag offensive delete link more


That's what I thought the question was asking at first as well, but really, they want to know the opposite. @pierre-yves samyn has answered correctly.

Jim K gravatar imageJim K ( 2017-10-21 17:43:56 +0200 )edit

answered 2018-11-07 13:24:28 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Editing in the formula bar IS necessary for any non-trivial spreadsheet job. Both mode are needed.

edit flag offensive delete link more


Which question this answer was intended to answer? :-)

Mike Kaganski gravatar imageMike Kaganski ( 2018-11-07 13:28:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-02 02:39:05 +0200

Seen: 1,999 times

Last updated: Nov 07 '18