In the Create simple drop down list dialog box, please configure as follows. Select the range of cells to output the drop down list, and then click Kutools > Drop-down list > Create simple drop-down list.Ģ.
CREATE DROPDOWN IN EXCEL INSTALL
With this tool, you can easily create a simple drop down list with several clicks only.īefore applying Kutools for Excel, please download and install it firstly.ġ. Here highly recommend the Create simple drop-down list utility of Kutools for Excel. So, this was all about making a drop down list in Excel.Quickly create a simple drop down list with an amazing tool This makes your dropdowns look more natural and no one can meddle with your dropdown values.īonus Tip: Instead of directly entering the source range in ‘source’ textbox you can also name your range and then use the same in ‘source’ textbox. Hit “OK” and your dropdown is created.Ĭosmetic Tip: If you are using a drop down with a table of values as source, then try to have this table on a separate sheet which you can hide later. In the ‘Data Validation’ window select “List” from the ‘Allow’ dropdown, check the ‘In-cell dropdown’ checkbox and in the ‘source’ textbox enter your table range (that we created in step 1).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.
CREATE DROPDOWN IN EXCEL 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.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)
