My "paste special - formula" in Excel pasts values and formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

terry.green.outspan@hotmail.com.NoSpam - 03 Nov 2006 21:10 GMT

I want to copy and paste formulas ONLY. When I use "paste special -
formulas" to copy and paste a row of cells containing both values and
formula, the cells containing values are copied and pasted as well as the
cells containing formula. How can I prevent the values being pasted?

(I have checked that the cells are formated "General" not "Text"). (The
formats are also pasted)

Thanks to anyone who can help.

Reply to this Message

Gary''s Student - 04 Nov 2006 13:03 GMT

See:

http://groups.google.com/group/comp.apps.spreadsheets/browse_thread/thread/d4c7a
a535eb7bec3/dd5f401c9c990f33?lnk=st&q=%22copy+formulas+only%22+excel&rnum=4&hl=e
n#dd5f401c9c990f33

Signature

Gary's Student

> I want to copy and paste formulas ONLY. When I use "paste special -
> formulas" to copy and paste a row of cells containing both values and
[quoted text clipped - 5 lines]
>
> Thanks to anyone who can help.

Reply to this Message