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 ...

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

In this article we will show you how to display multiple columns in a validation list in Excel. We will show you a method that can then be applied to your data.

Note that if ever you choose to add or delete an item from your list, Excel will automatically update the data validation: Make sure that the in-cell dropdown box is selected so that you're sure to ...

Figure A We’ll add a data validation control to this sheet. Click the Data tab, and then, click Data Validation in the Data Tools group. In the resulting dialog, choose List from the Allow dropdown.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

Go to Data on the Ribbon, and in the Data Tools group, choose Data Validation. The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole ...