Paste Special Formula Only

A

Ailish

H

Is there a way copying a mixture of values and formulae but when chosing the destination location only the cells with formula are transferred

Thanks
 
B

Bernie Deitrick

Ailish,

After you do your paste, do a Go To... Special.... / Constants Hit
OK, then hit delete.

HTH,
Bernie
MS Excel MVP

Ailish said:
Hi

Is there a way copying a mixture of values and formulae but when
Click to expand...
chosing the destination location only the cells with formula are
transferred.
 
Top