The DATA VALIDATION List function allows you to restrict the type of data or the values that users enter into a cell, like a dropdown list. This can help people work more efficiently by picking an item you create. We will get into all that in addition to some examples, tips, and tricks in this video.

My name is Tony and I have a degree in architecture and business administration. Excel is a powerful tool so don’t get discouraged. I’ve spent numerous hours, days, weeks working on my spreadsheets and years learning what I know. My hope is that my tutorials will be a quick way for you to learn what I know in a more condensed timeline.

The DATA VALIDATION List function is a must know essential tool that can be used in numerous applications and workflows. See my courses page for advanced uses of this function in combination with other functions or the related videos section for similar functions.