Copying

Closed
George - Aug 25, 2009 at 03:56 AM
peter.not Posts 11 Registration date Monday August 24, 2009 Status Member Last seen August 26, 2009 - Aug 25, 2009 at 07:17 PM
Hello,

I want to copy to another cell a result from a cell that has a formula and have that copied result 'freeze' irrespective to changes in the the with the formula. Is it possible? Thanks

1 response

peter.not Posts 11 Registration date Monday August 24, 2009 Status Member Last seen August 26, 2009 4
Aug 25, 2009 at 07:17 PM
I don't have a solution for you, but I do have the trick:

you have
A1=5
B1=6
C1=A1+B1

Select C1, and then COPY. Then, in menu bar, click edit > paste special > value

This way, the value of C1 becomes 11, not A1+B1
0