How to remove reffrence.
 

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?

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

"Rahul Gupta" wrote in message
...
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?

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

"JulieD" wrote:

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

"Rahul Gupta" wrote in message
...
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?

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

"Rahul Gupta" wrote in message
...
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

"JulieD" wrote:

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

"Rahul Gupta" wrote in message
...
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?