Excel tutorial
How to create a drop-down list in Excel
This whole video was made by AI.
Make your own at sayscreen.com
$1 for 7 days, then $49/month
- 2:29 video
- 12 steps
- Last verified November 21, 2026
A drop-down list lets people pick from the same few choices instead of typing their own. This video makes one in Excel for the web: it starts a blank workbook with a small task list, selects the three Status cells, opens Data Validation on the Data tab, chooses List and types To do, In progress and Done as the source. Each of those cells shows an arrow with those three options when you select it, and picking one fills the cell. For a longer list, Microsoft suggests typing the choices into an Excel table and selecting those cells as the source, so the drop-down updates when you add or remove one.
Steps
- Click Create blank workbook
- Type the headings Task and Status in row 1Type Task in A1, press Tab to move to B1, then type Status, the column that gets the drop-down, and press Enter.
- Add a few tasks under TaskHere: Draft newsletter, Book venue and Send invites.
- Double-click the right edge of column A's headerThe column widens to fit the task names.
- Select the Status cells beside the tasksDrag from B2 down to B4.
- On the Data tab, click Data ValidationThe Data Validation box opens on its Settings tab.
- Open the Allow menu and choose List
- Type the options in Source, separated by commasHere: To do,In progress,Done. Leave In-cell drop-down ticked: it's what puts the arrow in each cell.
- Click ApplyAll three Status cells get the drop-down.
- Click the arrow beside a Status cell and pick an optionHere B2 gets In progress.
- Widen column B the same wayDouble-click the right edge of its header so the whole status shows.
- Select another Status cell and pick from its listEvery Status cell has the same three options. Here Book venue gets Done.
Transcript
0:00In this video, you'll learn how to add a drop-down list to cells in Excel for the web, so a task's status is always picked from the same few choices.
0:10Start with a fresh file: click Create blank workbook.
0:15First, a small task list. In cell A1, type the heading Task. Press Tab to move across to column B. Type Status here, the column that will get the drop-down, and press Enter.
0:31Under Task, add a few sample tasks, starting with Draft newsletter. Then Book venue. And finally, Send invites.
0:48Double-click the edge of column A's header so it widens to fit the task names.
0:53Next, select the Status cells beside the tasks by dragging from B2 down to B4.
1:00With those cells selected, open the Data tab, where Excel keeps its data validation tools. Click Data Validation. This is where you control what can be entered in a cell, including drop-down lists.
1:15Open the Allow menu to choose what kind of entries these cells accept. Pick List, since we want a fixed set of choices.
1:24In Source, type the options separated by commas: To do, In progress, Done. Leave In-cell drop-down checked: that's what shows the little arrow in each cell.
1:37Click Apply to add the drop-down to all three Status cells.
1:41Now there's an arrow beside the cell. Click it to see your three options. Choose In progress, and it drops right into the cell.
1:51Double-click the edge of column B too, so the full status always shows.
1:56Every Status cell got the same list. Select B3 and its arrow appears as well. Open it for this task too. The venue's already booked, so pick Done. That's it: select the cells, open Data Validation, choose List and enter your options, and every Status cell gets its own drop-down.
Excel is a trademark of its owner. SayScreen isn't affiliated with, sponsored or endorsed by Excel; this video shows the public app as it looked when it was recorded, and we last checked the steps on November 21, 2026. If Excel has changed since, tell us at hey@sayscreen.com. Excel's own guide: support.microsoft.com/en-us/excel/get-started/create-a-drop-down-list.


