copy cell results and not underlying formulas
 

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???

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???

copy cell results and not underlying formulas
 

Hi John,
Wow too much information for one sentence..

Copy your cell with Ctrl+C, then paste it where you want it with
Edit, Paste Special, Values.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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???

copy cell results and not underlying formulas
 

To paste the values of a range that you have copied to the clipboard:

Right-click on the destination cell and choose Paste Special...

Then select Values and Click OK.

If you want to get fancy, you can bypass the mouse and do the whole
copying and pasting routine with the keyboard.

To copy:

Hold down Ctrl and press C

To paste values:

press Alt then E then S then V then Enter


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=527933