Follow the steps below to create a drop-down list using data validation in Excel. If you want to add a message pop up, you can click the Input Message tab and check the checkbox for “Show input ...

We will also show you how to make a colored and nested drop-down list. If you use Microsoft Excel as your preferred ... the drop-down menu. Go to Data > Data Validation. Select the List from ...