From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Create a drop-down list from table headers

Create a drop-down list from table headers - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Create a drop-down list from table headers

“

- [Instructor] This spreadsheet is set up so that we can type a name in C1 and then the data will be retrieved. But right now I've got to type it. Look at this, we got Anna and then let's look at Pete. There's Pete's data. But can you create a dynamic dropdown list so that we can add data to this table and have the dropdown list automatically update and pool the new data? The next thing is to add more data. In row nine, we want to find out if people use a PC, a Mac, or both. Want to add a new person in column H and make sure everything updates. So yeah, you have to write a formula for cell C4 so that it will pool the PC Mac data. Go ahead, pause the video. Make that happen and come on back. OK, let's do it. I'm going to go here. I'm going to add this data first. Mac, PC, PC, both, Mac, PC. Great. Now let's make the dropdown list. Highlight the headers. And then go up here, Names. Then go to…

Contents