|Your cart is currently empty|
Tips from MCT Anne Walsh's Data Validation seminar. Includes:
How do I set a maximum number for a cell?
How can I warn people the entry seems wrong, but let them proceed?
How do I only allow values between certain amounts?
How do I extend the data validation?
How do I copy the data validation to another part of the sheet?
How do I stop people changing some entries?
How do I only allow items from a specific list?
How do I delete a validation list?
How do I remove data validation?
I don't even want others to open my file.
OK, I'll let them look, but not touch.
I only want certain dates entered.
I only want people to enter certain text lengths
I don't want duplicates
I want others to sort & filter, but not anything else