View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default copy cell results and not underlying formulas

Right click in the cell containing the formula and choose 'copy'.
Right click in the cell where you wish to paste the value and choose "Paste
Special".
Then click on:
<Values
<OK
<Esc

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"john.jacobs71" wrote in message
...
This is very basic I am sure, but how do you copy and paste the results of

a
cell which is the product of a formula to a different cell without having

the
formula tag along and operate on the cells which relate to the target cell

in
the same relation that it relates to the copied cell???