Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|