How to remove reffrence.

R

Rahul Gupta

Say if have added the sum of two cells. Now no longer the reffrence to those
cell is need but the sum is need in the third. How do i do that?
 
J

JulieD

Hi Rahul

click on the cell containing the sum and choose copy
then edit / paste special - values
now the formula will be turned into the result and the source columns can be
deleted if no longer required.

Cheers
JulieD
 
R

Rahul Gupta

Hey Thanks,

That helped but only in case of pasting it to a new/same place. What do i do
to remove the reffrence from there itself?

Rest its working.

Rahul
 
J

JulieD

Hi

i'm not sure what you're asking
say you have the following worksheet

............A.................B...............C
1.........5................10..............=A1*B1

what do you want to see instead?

Cheers
JulieD
 
Top