Paste Special values only

G

Guest

I have a spreadsheet - users enter data in the sheet and need to copy to
other similar cells. However I want them to only Copy - Paste Special
(Values) so that the formulas and conditional formats are not copied with
them.

Can I either force Paste Special or disable normal paste; or is there a way
of "freezing" formulas and conditional formats to their original cells.

Thanks

Andrew
 
G

Guest

Hi Andrew,

I had the very same problem - and by "hiding" the formulas in the cells and
protecting the worksheet - when my users now copy & paste it only copies the
values.

Hope this helps.

Regards,

WendyUK
 

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

Paste special from cells without formulas/formats 2
Paste, Paste Special 2
How do I copy cells containing drop downs? 3
Paste Special Values 2
Copy and Paste 3
Copy formula only from one spreadsheet to another 1
Edit Paste Special Formulas 7
Paste Special 3

Top