Updated date:

How to Create a Simple List Box in Microsoft Excel 2016

Joshua has work experience in manufacturing, distribution, and aerospace. He received his BBA in accounting from Kent State University.

Create Your List Data

An illustration of a list box.

An illustration of a list box.

Creating a list box in Excel can save you the hassle of keying in repetitive entries into your spreadsheets. This is especially true if your spread sheet 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 to put the data that you want to appear in your 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 then on the data validation drop-down arrow.

Go to the Data Tab

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

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

Find Data Validation

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

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

Select List Option

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

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

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

Go back to the cell(s) that you selected prior to selecting the data tab. There should be a drop down arrow to the right of 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

Create a List Box in Excel

To learn more about using Excel data validation tool for business applications I recommend the following book. I have been using the Excel Bible for years to improve my understanding of all aspects of this Microsoft product.

The Excel 2019 Bible

Related Articles

How to Concatenate Data in MS Excel

How to Add the Developer Tab in MS Excel 2016

Create a Macro Button in MS Excel 2016 to Filter Data

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