Skip to main content

How to Create a Simple List Box in Microsoft Excel

Joshua earned an MBA from USF and he writes mostly about software and technology.

An illustration of a list box

An illustration of a list box

Creating a List Box in Excel

Creating a list box in Excel can save you the hassle of keying repetitive entries into your spreadsheets. This is especially true if your spreadsheet has hundreds of records. In this tutorial, we create a simple list box that will allow you to select from a list of data.

First, find a range and add data to it. This is the data that you want to appear in the list box. I usually create a new sheet to store my data sets.

Next, select cell(s) or a column where you would like the list box to appear. Click on the data tab and then on the data validation drop-down arrow.

Go to the Data Tab

Go to the Data Tab

Next, click on 'data validation' from the drop-down menu.

Find Data Validation

Find Data Validation

Select 'List' from the 'Allow' drop-down menu.

Scroll to Continue
Select List Option

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.

Input source

Input source

Go back to the cell(s) that you selected before selecting the data tab. There should be a drop-down arrow to the right of the cell(s) that will allow you to select data from the data set you created.

how-to-create-a-list-box-in-ms-excel-2016

To learn more about using functions in Excel I recommend purchasing Excel Formulas & Functions For Dummies.

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2017 Joshua Crowder

Related Articles