Formula copies when only answer is wanted

R

Rhino721

Excel 2003, When I copy a group of cells with a formulas in them. The
formulas copy and try to adjust to match what they were before. I only want
the sum of that solution to be copied. What am I missing?
 
R

Rhino721

Thank you

David Biddulph said:
If you want to copy the resulting values, rather than the formulae, use
Copy, then select the destination and use Edit/ Paste Special/ Values.
Click to expand...
 

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

Hiding sum formula answers in select cells 5
Automatically copy formula in column when adding new row.... 2
Incrementing Formula by Column Instead of by Row 1
Time Sum in Excel 1
Excel Help to copy information from one row at a time to another sheet 1
Adjusting formulas by copying across cells w/o changing the refere 6
Copying a formula but only getting the result 3
Return cell content in a matched range 2

Top