Copy and paste special

L

Lakshmi Vinay

Hello
I don't know this is a stupid question, but what is the difference between a
regular copy and paste routine and the copy and paste special -->Formulas on
a cell which has the result of some calculation?
I tried the copy and paste special on a cell that had the formula =a1+a2.
When I tried to do the paste special -->formulas into a cell 2 columns
across, the formula modified as =c1+c2.
If this is indeed what is to be expected, why can't we just use the regular
copy and paste which will give the same result?
I am not keen on giving the absolute references to the formula to make sure
it doesn't change.
Please help.
Thanks.
 
B

BSc Chem Eng Rick

Paste Special only pastes the selected element.

Try this, put a border on your original cell and make the text bold. Now
compare the difference between Paste Special --> Formulas and just Paste.
 

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

Top