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).