Data Validation Tip Card

SKU: 315

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:
Related Products
SKU: 314
2-Page Lamindated Tip Card for Excel Conditional Formatting. From Anne Walsh and Bill Jelen.
SKU: 273
Excel Charting Tips from Bill 'MrExcel' Jelen
SKU: 316
2-sides laminated tip card of tips for Data Cleansing. From Microsoft Certified Trainer Anne Walsh.