Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Feautue
When I copy a figure that is the sum of a group of cells and try to paste the
figure in the workbook I'm working in, I cannot paste the figure. It appears that Excel is copyies the formula and attempts to calculate the formula for the new cell. When I copy the figure and paste to a new workbook, I can paste the figure i copied? What is causing me not to be able to copy and paste the figure in the same workbook I'm working in? Thanks for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Feautue
Click the figure you want copied (the one figured by the formula) and copy it
using your preferred method (Ctrl+V and the like...) Select the cell you want to paste the figure to and select EditPaste Special... At the prompt, select "Value" and click "OK" "ManhattanRebel" wrote: When I copy a figure that is the sum of a group of cells and try to paste the figure in the workbook I'm working in, I cannot paste the figure. It appears that Excel is copyies the formula and attempts to calculate the formula for the new cell. When I copy the figure and paste to a new workbook, I can paste the figure i copied? What is causing me not to be able to copy and paste the figure in the same workbook I'm working in? Thanks for the help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Feautue
1. The copying between one sheet and another in the same workbook will copy the
formula. EditPaste SpecialValues if you want just the value. Same for copying between workbooks if you have one instance of Excel running. 2. The copying between workbooks and just getting the value means you have two instances of Excel running with a workbook open in each instance. Gord Dibben MS Excel MVP On Fri, 7 Dec 2007 13:50:01 -0800, ManhattanRebel wrote: When I copy a figure that is the sum of a group of cells and try to paste the figure in the workbook I'm working in, I cannot paste the figure. It appears that Excel is copyies the formula and attempts to calculate the formula for the new cell. When I copy the figure and paste to a new workbook, I can paste the figure i copied? What is causing me not to be able to copy and paste the figure in the same workbook I'm working in? Thanks for the help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Feautue
MEAD5432
Thank you for the help...You solved my problem "MEAD5432" wrote: Click the figure you want copied (the one figured by the formula) and copy it using your preferred method (Ctrl+V and the like...) Select the cell you want to paste the figure to and select EditPaste Special... At the prompt, select "Value" and click "OK" "ManhattanRebel" wrote: When I copy a figure that is the sum of a group of cells and try to paste the figure in the workbook I'm working in, I cannot paste the figure. It appears that Excel is copyies the formula and attempts to calculate the formula for the new cell. When I copy the figure and paste to a new workbook, I can paste the figure i copied? What is causing me not to be able to copy and paste the figure in the same workbook I'm working in? Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |