From the course: Excel: Productivity Tips

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating drop-down menus with Data Validation

Creating drop-down menus with Data Validation - Microsoft Excel Tutorial

From the course: Excel: Productivity Tips

Start my 1-month free trial

Creating drop-down menus with Data Validation

“

- [Instructor] All right, for this pro tip, I want to talk about one of my favorite Excel tools: Data Validation, and specifically, how to use Data Validation to create dropdown lists within cells. Now, quick summary here, Data Validation is all about limiting the values that a certain cell can accept. So you can say, I only want this cell to take whole numbers or positives or negatives, or date ranges, or data types like text or values. And you can access that menu from the Data tab, click Data Validation. Now within that Data Validation menu, you've got an option called a List. And the List option is the one that I use most frequently. That's what's going to allow you to create that dropdown menu containing a specific set of items. And you can either type those items directly in the dialog box separated by comments, or you can reference a cell range containing your list. Now, in this case here, we've manually typed them…

Contents