Ask Your Question

edit directly in cell

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

Exceluser 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

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: 695 times

Last updated: Nov 07 '18