Data Validation is a feature in Excel that allows users to pick from a list of rules to limit the type of data that can be entered into a cell. Follow the steps below to create a drop-down list ...

How to add a data validation drop-down in Excel Now that you know how users and your data will benefit from a drop-down list, let’s add one to D2. First, add the short list ( Figure A ) to B3:B6 ...

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.

Under the Data tab, click on Data Validation. 2. In the settings tab of the pop-up window, under Source, add or delete list items as necessary, making sure all items are separated with a comma and ...