Paste Special values only
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 |
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 "AJPendragon" wrote: 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 |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com