paste special (values)

A

AJPendragon

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.
Click to expand...
Someone has suggested hiding the formulas - but thst just hides the formulas
from view - it does not stop them being copied to other cells.
 

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

how to copy and paste value from one sheet to another 4
Paste Special values only 1
Populating a Text Field with a value in an Excel Sheet 0
Time Sum in Excel 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Conditional formula yeilds non-number result 6
Paste Special Values 2
Combing a V Lookup result with ("00"&A2)*1 in same formula 4

Top