How to configure an Excel cell, Excel Cell Range, Excel Column or Excel Row so that each of its cells will allow a user to select a value from a drop down list (combo box) rather than typing?
- Select the cell, range, row or column you want to display with a drop down list
- Select “Data Validation” from “Data Tools” Section in the “Data” Menu (refer to the screen shot below)
- In the dialog box, Select “List” from the “Allow” section
- Provide the list of possible values in the “Source” section (you can either type in a list of values each separated by a comma or select a range of cells in the sheet that you want to use)
- Click OK and enjoy!
3 thoughts on “ILT – How to Add a Drop Down List (ComboBox) Into an Excel Cell”
What’s up, I just noticed that occasionally this site renders a 404 server error message. I thought that you would like to know. Regards
Hi Mark, Thanks a lot for letting me know. I will look into this.
Great web site you have got here.. It’s hard to find high quality writing
like yours nowadays. I really appreciate people like you!