Select where you want the drop-down list to appear. Click the Data tab and select Data Validation in the Data Tools group. A Data Validation dialog box will appear.

In this post, we will show how to create a dropdown list in Microsoft Excel. We will also show you how to make a colored and nested drop-down list.

Drop-down lists aren't as tricky to use as people think, so you should be able to figure it out without the dreaded hour-long YouTube tutorial. Launch Excel and select the cell where the list will ...

This type of control is truly one of Excel’s most helpful features, because the drop-down list can be almost anything. In this case, we’ll use a list of color names at the sheet level.

Microsoft Excel users, here's a quick tip on adding a condition to a drop down list.