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.
#HOW TO MAKE A DROP DOWN LIST IN EXCEL THAT FILTERS HOW TO#
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.