Formulas

S

sw0318

How do I change one formula and have it change all other formulas within a
worksheet that are the same.

Example:

=E3*F3*30*0.0950498

I have this formula in many places within a column. I want to change just
one cell and have the change in all cells with this formula.
 
P

Pete_UK

If you defined that as a named formula, then you could just change the
formula in the definition and the cells that use it would change
automatically.

Alternatively, you could just put that formula in one cell (eg X1) and
then change all occurrences in your sheet to $X$1 (you could use Find
& Replace for this).

Alternatively still, you could highlight all the cells and use Find &
Replace (CTRL-H):

Find what: E3*F3*30*0.0950498
Replace with: your_amendment
Click Replace All

Hope this helps.

Pete
 
J

JBeaucaire

That's almost enough info, but we'll see

If that formula is sequential cells and the relative references ar
adjusting all the way down, simply select the entire range of cells
press F2 to edit one of them, the press CTRL-ENTER to apply that sam
change to all the cells. The relative portion of the references wil
stay relative, any absolute changes will apply absolutely to each cell

You can even select non-adjacent cells and do the same thing
Shift-click on each cell until you have them all selected, then F2 t
edit one, and CTRL-ENTER to apply the changes

Does this work for you
 
J

John

Hi
Go to > Edit> Find, type your formula in > Find What: =E3*F3*30*0.0950498
Replace with: and type the correction. press Find All > Replace All
Regards
John
 
Top