From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Create drop-down lists

Create drop-down lists - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Create drop-down lists

“

- We got this list of people and we are going to put them in a table and we would like drop-down list so that we can so we can select their availability and their specialties. For availability the drop down list should allow capital Y, lower case y, capital N or lower case n. Then the specialties should show Lighting, A/V, Costume, Editing and Camera. So pause the video, create these drop down lists inside a table and come back and you can watch me do it. All right welcome back. Here we go put this into a table. Data, okay we got format as table. Select there all right, no filter buttons. Now what I'm going to do is highlight this column. Now go to data, data validation I want a list in cell drop down and ignore blank leave those as they are. Now we want to have YyNn those are our options. Okay, so lets check that out. All right, yes so I can select Y or if I'm typing I can go Y, Y or if I had my cap locks on it will…

Contents