Copy and Paste Feautue

M

ManhattanRebel

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.
 
M

MEAD5432

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 Edit>Paste
Special...

At the prompt, select "Value" and click "OK"
 
G

Gord Dibben

1. The copying between one sheet and another in the same workbook will copy the
formula. Edit>Paste Special>Values 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't copy and paste equations 0
copy and paste 4
How to copy a range of cells and paste into a new workbook in differentcolumns 3
Sudden Change in Copy & Paste Format 2
Auto Fill Format or Copying Formulas 1
Copy and Pasting Formulas 4
Macro to copy value in field and insert it into filter 2
Copy Paste problem 3

Top