View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richhall Richhall is offline
external usenet poster
 
Posts: 19
Default Copy and Replicate exact formulas

Hi

I have a range with formulas in, say A1:F50. I want to copy the exact
formulas over to G1:L50, but if I select the range and copy and paste,
it changes all the values in the formulas, when I want an exact
replica, not adjusted ones? How can I do this? At the moment I'm doing
it and just doing a bulk find and replace for each bit back to the
original. I've been into paste special, and just selected formulas,
but is still amends the formulas.

Cheers

Rich