updating formulas in groups

[flya]

how do u update formulas in groups like as in column wisr
rather then updating them individually, because this
would save me time, + i am required to find out how to do
it so if u know how to do it can u plz tell me, thnx

 

[Govind]

Hi,

If you want to do the same correction across the formulas in columns,
then select the entire column and do a find and replace.

lets say you want to replace all cell A1 in all the formulas to cell A2,
then choose the entire column and click on find and replace.Enter find
column as A1 and replace with as A2. But be careful to be more
descriptive(like giving :A1, if thats how it exists in the formula)so
that you dont replace some other values.

Regards

Govind.