Now, navigate to Data > Data Validation. Next, select the cell on which you are planning to create a drop down. First with an Excel sheet opened, enter the values that you are planning to populate in your dropdown in a table. Below is a step by step procedure to do this: You can enter the values that you want to see in your dropdown as a table and then use the range of this table in ‘Source’ column. This is fine if you are planning to create only small list boxes, but you have a large list of values that you want to populate in your drop down list then there is a better method. A better type of data source for dropdowns:Īs you have already seen that you can enter the values of a dropdown directly in the ‘Source’ textbox. Excel dropdowns can have a maximum of 32,767 values. 
You should manually adjust it according to the longest value in your dropdown.ģ. The width of your dropdown list is not set automatically. It can only be deleted after selecting the dropdown, click ‘Data Validation’ option and in the ‘Data Validation’ window press “Clear All” button.Ģ. You cannot delete a dropdown by pressing delete key. Recommended Reading: How to add a Checkbox in excel Few Important things about Excel Drop downs:ġ.
After this hit the ‘OK’ button and your dropdown is ready to be used. Also, please make sure that the checkbox ‘In-cell dropdown’ should be checked. And in the ‘Source’ textbox enter the values that you wish to have in your dropdown, these values should be separated by a comma (,). In the ‘Allow’ dropdown, select the “List” option. Now, a ‘Data Validation’ window will open. Next, navigate to ‘Data’ tab in the Excel Ribbon and then click the ‘Data Validation’ button. First of all open your excel sheet and select the cell on which you wish to create a drop down. And today I will guide you on making a drop down list in Excel. This approach is better because it validates each input from user against a predefined set of values and hence users can only input valid and excepted values.Įxcel also has a feature that allows you to create drop down lists. 
It is always good to have drop down lists for accepting user inputs. Drop down list is a tool that can help you to force users into selecting a specific value from a predefined set of values.
0 kommentar(er)
