Data Validation Tips (Electronic Download)

SKU: 309
Qty: - +
   - OR -   

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

Currently there are no reviews for this product. Share your opinion with others, be the first to write a review.

Add Your Review

Your Name:
Email Address:
Note: HTML is not translated! Your email address will not be shared with anyone.
Your Rating: 5
Your Name:
Your Email:
Friends Name:
Friends Email: