View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Changing Multiple Formulas

Select your range
In the menu select Edit Replace Find what: 390 Replace with: 370
Replace All

"japc90" wrote:

I have a workbook wih several worksheets. Many of the cells have
similar formulas (the sum of the value of two cells located on a
separate worksheet within the same workbook divided by 390). I need to
change the number 390 in all of these cells to 370. Is there a way to
do this without manually going through every cell?

Thank you.