How to Create a Simple List Box in Microsoft Excel 2016
First, find a range to put the data that you want to appear in your list box. I usually create a new sheet to store my data sets.
Create Your List Data
Next, select cells or a column where you would like the list box to appear. Click on the data tab then on the data validation drop down arrow.
Go to the Data Tab
Next click on 'data validation' from the drop down menu.
Find Data Validation
Select 'List' from the 'Allow' drop down menu.
Select List Option
Click in the source box. Now select the range where you inputted your data set. Select 'OK' when the range you selected appears in the source box.
Go back to the cells that you selected prior to selecting the data tab. There should be a drop down arrow to the right of the cell that will allow you to select data from the data set you created.