Excel Drop Down List to Avoid Repetitive Typing

Adding excel drop down list to your excel sheet is very useful if you are going to use repetitive words or phrases through the rows. Therefore enter below data to excel sheet or download the file from here to learn how we can use it in excel sheets. Assume this data represents the type of mobile phone using by the managers of ABC company.

Mobile Phone

Samsung

Sony

Sony Ericsson

Nokia

HTC

BlackBerry

There are few methods to add excel drop down list to a sheet.

1. Use direct reference to the Values.
2. Using named range as a reference
3. Use comma separated values

Use Direct Reference to add Excel Dropdown List

1. Select the cell you are going to have excel dropdown list.
   
   
   
2. Then Select data tab.
3. Then Click on data validation. Now you have pop up window to validate your data.
4. Then Select settings tab and 'list' from drop down list for allow parameter.
5. After that select the range where you have entered phone makers as source parameter.
6. Finally Click OK.

Use Named Range to add Excel Dropdown List

1. Select all phone models.
2. Then Rename that range as phone. (you can see position where you have to enter new name just above column A)
   
3. After that Select the cell you wants to add drop down list.
4. Then Select data tab.
5. Then Click on data validation. Now you have pop up window to validate your data.
6. Then Select settings tab and 'list' from drop down list for allow parameter.
7. After that Enter '=phone' in to source parameter.
8. Finally Click OK.

 

Use Comma Separated Values to add Excel Dropdown List

1. Select the cell you are going to have excel drop down list.
2. Then Select data tab.
3. Then Click on data validation. Now you have pop up window to validate your data.
4. Then Select settings tab and 'list' from drop down list for allow parameter.
5. After that Enter phone makes one by one separated by comma to the source parameter field.
6. Finally Click OK.

tab.

Then Click on data validation. Now you have pop up window to validate your data.

Then Select settings tab and 'list' from drop down list for allow parameter.

After that Enter phone makes one by one separated by comma to the source parameter field.

Finally Click OK.