Changing multiple formulas at one time

P

poorsister

I have a workbook with 30 worksheets that all have approximately 100 formulas
that read =(Cell)*.0342. I want to change the formula to read
=(Cell)*($AA$1) so I can change the value to $AA$1 as inflation changes. Is
there a way to change multiple cells at once?
 
D

Dave Peterson

Try grouping your sheets.
click on the first worksheet tab and ctrl-click on the others.

Then edit|replace
What: 0.0342 (include the leading 0!)
with: $a$1
replace all

Rightclick on any of the grouped worksheets and select ungroup sheets.

(I'd save first and verify after!)
 
P

Pete

Highlight the cells which have the formulae in them, then do Find &
Replace (CTRL-H). In the Find box you need to enter:

..0342

and in the replace box:

($AA$1)

then click Replace All.

Pete
 
Top