Copying formulas with changing cells

  • Thread starter Thread starter KenJ
  • Start date Start date
Hi,

I'm using Microsoft Office 2003. I have formulas in a particular column, but
now I need to change from one column to another with out changing the
formula. e.g =R20/12 now needs to be =C20/12. how do I do this without having
to do each one separately?
 
Your subject says "with" changing cells. Your message says "with out"
changing. Which one do you want?

When you reply, tell us what happens when you simply copy the cell. If it
doesn't do what you want, tell us what it did, and what you want instead.

Regards,
Fred.
 
I needed to change cells...without changing the formula. Like =R20/12 needed
to be changed to =C20/12 for an entire column. I got it done with find and
replace.

Thanks
 
Back
Top