Now, let’s insert the data validation control. Using the simple demonstration sheet shown in Figure A, click B2. Feel free to use one of your own files if you like or choose another cell.

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