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.


--
SW

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

On Jan 27, 5:28*pm, sw0318 wrote:
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.

--
SW

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
"sw0318" wrote in message
...
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.


--
SW

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

If that formula is sequential cells and the relative references are
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 same
change to all the cells. The relative portion of the references will
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 to
edit one, and CTRL-ENTER to apply the changes.

Does this work for you?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=55262