Paste Special Formula Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top