Skip to main content

3 Ways to Create a List Box in Excel

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

A list box can provide an easy way to display information. There are three ways this useful tool can be created that may meet different needs.

The illustration shows a list box with a list of text number options.

The illustration shows a list box with a list of text number options.

1. List Box From a Range

One of the easiest ways to create a list box is creating the list from a range of values. The range of cells used can be vertical like the one on the illustration or horizontal.

three-ways-to-create-a-list-box-in-excel

First, select cell(s) where you like the list box to appear. Select the data tab in the Excel ribbon, followed by clicking on the data validation option.

three-ways-to-create-a-list-box-in-excel

A few options will appear. Select list under the allow option and add the cell range where the list appears to the option named source.

three-ways-to-create-a-list-box-in-excel

After selecting OK, the list box will appear in the cell selected at the beginning of the process.

three-ways-to-create-a-list-box-in-excel
Scroll to Continue

2. List Box From a Named Range

Like using a range, you may want your list to come from a named range. This option may be preferred if cell references for a list are expected to expand in the future. Using a named range will allow you to insert new cells into the named range without having to change a range in the source.

To save the list range as a named range, select the range and create a name in the reference field box shown in the upper left-hand corner of the below illustration. Next, tap on the enter key and the range will be saved.

three-ways-to-create-a-list-box-in-excel

As instructed earlier, select the cell(s) where you like the list box to appear. Select the data tab in the Excel ribbon, followed by clicking on the data validation option.

three-ways-to-create-a-list-box-in-excel

Lastly, type the name of the range followed by clicking the OK button. The same result as the first option will appear.

three-ways-to-create-a-list-box-in-excel

3. List Box Created With Hidden Values

This option can be used when you don’t want the values In the list to be seen or easily edited in the spreadsheet.

Under the data validation section, add each value to appear in the list in the source section separated by a comma.

three-ways-to-create-a-list-box-in-excel

This result will also be the same as the first two options.

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.

© 2022 Joshua Crowder

Related Articles