Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove spaces in text in excel | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove Email address header | Excel Discussion (Misc queries) |