0

Based on column A TRUE/FALSE values column B will display "True" or "False", formula=IF(A1;"True";"False"). Formula is copied (by dragging) to multiple rows below.

How do I change the formula in all rows in B to =IF(A1;"Sooo true";"False") without dragging or selecting the column B? I would like to click cell B1, change the text in formula and propagate that change to all cells in column B that copied the formula, so that in all cells that previously was "True" now would be "Sooo true".

Lets assume that cell B5 has value entered by hand ="INACTIVE CELL" that is meant to stay unchanged (dragging would overwrite that cell's value back to formula).

Jakub Sengerski
  • 3

1 Answers1

1

Unless there is a third-party add-on, I don't think Excel has such a capability (but I may be wrong). The picture below illustrates two possible solutions:

  1. (columns A,B in picture) In the original setup, configure it so that the values returned by the formula on not hard-coded in the formula but rather reference another cell you can change.
  2. Select the cells with the formula in question, press ctrl+h (find and replace), enter the hard-coded text in the formula you want to change and then the text you want to replace it with. The, press "replace all"

enter image description here

Brian
  • 1,085