Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to replicate formulas | Excel Worksheet Functions | |||
Exact Copy | Excel Discussion (Misc queries) | |||
Exact formula copy. | Excel Discussion (Misc queries) | |||
How to do the exact copy of a formula | Excel Worksheet Functions | |||
Re post the exact formulas | Excel Worksheet Functions |