How to disable formula editing directly in cell?

asked 2019-12-02 14:56:42 +0100

mtibbi gravatar image

During the formula edition process, the editing line covers cells in the vicinities, which sometimes bring difficulties to the edition process. This is especially true if you have long formulas in your spreadsheet. For this reason I prefer to edit formulas only in the formula bar.

edit retag flag offensive close merge delete


And what prevents you from following your preferred mode of inserting formulas? Anyway - afaik you can't achieve that. This would require that cells know in advance, what you are going to add. Will it be a number -> allow direct input; will it be text -> allow and will it be a formula -> don't allow (and what about adding =this is not a formula?).

Opaque gravatar imageOpaque ( 2019-12-02 16:31:02 +0100 )edit

My question is related to editing formulas which is a different process compared to inserting formulas. Let me try explain the problem with an example. Suppose you have a long formula such as : =INDEX($changeMatrix.$D$13:$E$751;SMALL(IF($changeMatrix.$D$13:$D$751=$draft.G$18;ROW($changeMatrix.$D$13:$D$751));ROW(15:15))-12;2). Suppose this formula is in cell A1 and you want to edit it. You press F2 in order to edit the formula, then an editing area is created for you to make changes in the formula. In my case this editing area was a rectangle covering from A1 to B10. But, for editing the above formula I needed to refer to one or two cells which are now underneath editing area and I cannot see the cells, let's say A5 and B5, because editing area is above them. A ...(more)

mtibbi gravatar imagemtibbi ( 2019-12-03 01:44:47 +0100 )edit