How to create List Box in Excel

You want to create a list of options (List Box) for your Excel file but do not know how to do it. In this article, TipsMake.com would like to guide you how to create List Box in Excel most accurately. Let's follow along!

How to create List Box in Excel Picture 1

Step 1 : Set up the list table you want to create.

How to create List Box in Excel Picture 2

Step 2 : Use your mouse to select the area you want to implement List Box.

How to create List Box in Excel Picture 3

Then on the toolbar you select Data -> select Data Validation.

How to create List Box in Excel Picture 4

Step 3 : A Data Validation windowappears, you perform in turn:

- At Allow select List .

- In Source, select mouse with the list you created in Step 1.

Then click OK .

How to create List Box in Excel Picture 5

And here is the result we will achieve:

How to create List Box in Excel Picture 6

Also if you do not want to create an external list column, then in the Source section, please fill in the options there. Then select OK .

How to create List Box in Excel Picture 7

And we will have a similar list box:

How to create List Box in Excel Picture 8

Thank you for following the article. I wish you successful implementation!