Copying a table with formulas

**Cmorgan** · 05-20-2012, 10:45 AM

Afternoon,

I'm trying to copy and paste a table that I have already created, however, when I do this it automatically changes the formula cell values, as I haven't used $. Is there any way to stop this?

Thanks

**alansidman** · 05-20-2012, 10:55 AM

Are you looking to paste only the values derived from the formula in the original location? If so, use Paste Special Values. If you are looking to keep the original references then you will have to use the absolute values (ie. the $ sign)

Alan

**Cutter** · 05-20-2012, 10:55 AM

You want the formulas copied to the new location and refer to the same cells as the original table?

**Cutter** · 05-20-2012, 11:06 AM

If you want to copy formulas and paste them so that the results would be the same as having copied them from the formula bar then:

Select the range that you want to copy.
Ctrl+H
Find: =
Replace: >> (or something else that you are certain does not already appear in that range)
Replace All
Copy your range and paste it in new location.
Reverse the Ctrl+H on each range (original and new)
Find: >>
Replace: =
Replace All