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

Head to the Excel Options menu (through the File menu on Windows) or within Excel Preferences on Mac. Open the Ribbon menu to Popular Commands and click the Developer option on the right, then Save.

To create a drop-down list in Excel, you will use the Data Validation feature. ... To create a list that automatically updates when you add new items, use the OFFSET and COUNTA functions. 3.

How to base a data validation dropdown on an array in Excel Now we’re ready to create the data validation dropdown that will display the unique list in column H. To begin, select J2 and then do ...

We’ll create two Excel drop down lists based on this simple data set. We need two Excel drop down lists. The first Excel drop down list will set the condition, the region.