Question of the day: How to Create Customized Drop Down Lists In Excel?

excel drop down list data validation

excel drop down list

How To Create A Custom Drop Down List In Excel By Using Data Validation?

In our previous countif example, the user wanted a spreadsheet that would count each one the projects at the bottom of the spreadsheet. This example could be enhanced by  a creating drop down list using data validation.

Data validation lets you create customized an excel drop down list in your spreadsheet.  The drop down list give you control over the options the user has when adding data to your worksheet.

Create a customized drop down list by using the Data menu or ribbon options. In Excel 2007:

  1. Highlight the range of cells where you want to see the drop down list appear.
  2. Click the Data option on the ribbon. Select Data Validation. A drop down list appears. Select Data Validation again. The Data Validation window appears.
  3. Click the Settings tab.
  4. Change the Allow option to List
  5. In the source group, type the options you want to see in the drop down list.  Separate the options with a comma. Notice no space appears before or after the comma.
  6. Click Ok.
  7. Click in any of the cells highlighted and notice the drop down list appear!


excel drop down list data validation


Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.