Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste special values | Excel Worksheet Functions | |||
Paste Special | Excel Discussion (Misc queries) | |||
Paste Special | Excel Discussion (Misc queries) | |||
Paste Special Question | Excel Discussion (Misc queries) | |||
i special paste | Excel Worksheet Functions |