This Excel video lesson walks you through how to set up Data Validation rules. The main purpose of Data Validation is to set up rules so that only certain types of information can be entered into cells (which helps to reduce manual entry error).
Make sure to download the most recent Master Workbook to follow along.
Let me know if you have any questions!
Pingback: A Complete Introduction to Excel | MBAx.me
Awesome
This site is so damn useful that I’m close to registering, despite how much I hate doing it lol.
But I had a question/issue that came up as I was practicing this on my own that I would hope someone might be able to help clarify for me.
When doing data validation – you can only have 1 list? It won’t let me combine ranges, so
instead of being able to do for example:
=(List_Fruits, List_Vegetables, List_Meats)
I had to make one master list, List_Food for all the items.
Heres what my range looks like for List_Food (each [ ] bracket being a cell)
[--FRUITS--]
[Apple]
[Orange]
[--VEGGIES--]
[Tomato]
[--MEATS--]
[Steak]
[Chicken]
So now my master List_Food is a that entire range, vs each one which just included the items.
The difference here being my List_Food range includes my header titles, like [--FRUITS--] … which I don’t want to be a “good valid data” choice. This also makes it harder to distinguish which item is which for later uses.
The whole thing might be a little silly and unnecessary but I was just wondering if anyone had any ideas/solutions/similar problems they could share/discuss.
I suppose I could have posted this on reddit for discussion, rather than here
Anyway, thanks again for such a great site!
Unfortunately after looking into it, it doesn’t appear that you can combine multiple ranges using Data Validation. The only options would be to combine into one list as you mentioned (either via copy/paste or a macro).
Glad you’ve enjoyed the lessons!
Thanks for checking, I appreciate your time!
Thanks for these Ben, I am finding them really useful. Please keep them coming!
thank you very much for these tutorials.