View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JPS JPS is offline
external usenet poster
 
Posts: 47
Default Adding to an existing formula

I inherited a workbook that has about 20 spreadsheets and I need to add a
round function to 250+ formulas in one of the spreadsheets. The formulas are
in a set range but their references are not relative to allow me to update
one formula and then copy to other cells. A coworker and I have concluded
that each formula will need to be updated individually. Does anyone know of a
shortcut to update all of these formulas?

Thanks,

--
JPS