You can follow below steps to quickly create a drop-down list with ease in Excel.

1. Click Kutools > Drop-down List > Create simple drop-down list to enable this feature.

2. In the opening Create simple drop-down list dialog, please:
1) In the Apply to box, please specify the range you will add the new drop-down list for;
2) In the Source section, please check the Enter a value or reference a cell value option, and type in or select the data source you will create the drop-down list based on;

Tips: If you need to type in the data source manually, please separate the drop-down list options with comma, such as “Apple,Grape,Mange,Orange,Peach”.

3. Click the Ok button.

Now the drop-down list is created based on the specified data source and added to the specified range immediately.

The Simple Drop-down list feature also supports to quickly create a drop-down list based on your custom list stored on your computer.

1. Click Kutools > Drop-down List > Create simple drop-down list to enable this feature.

2. In the opening Create simple drop-down list dialog, please:
1) In the Apply to box, please specify the range you will add the new drop-down list for;
2) In the Source section, check the Custom Lists option;
3) In the Custom Lists section, click to select a custom list you will create the drop-down list based on.

3. Click the Ok button.

Now the drop-down list is created based on the specified custom list immediately.

1. If you are not familiar with this Create simple drop-down list feature, you can click the Example button to open the example sheet. However, this operation will close the current dialog.

2. You can easily remove the drop-down lists from a range as follows:
(1) Select the range containing drop-down lists you will remove;
(2) Click Kutools > Prevent Typing > Clear Data Validation Restrictions.