Data Validation from an Existing List


In this topic, we will create a list and use it to validate data in an Excel spreadsheet.


Steps:

  1. Select the cell(s) you want to validate. 

     

    Click the Data tab.

    Step 1
  2. Click the Data Validation drop down menu.

    Step 2
  3. Click Data Validation

    Step 3
  4. Settings Tab:

     

    Click the Allow drop down menu.

    Step 4
  5. Select List 

    Step 5
  6. Click in the Source: field.

    Step 6
  7. Type your values in the Source Box.   Place a comma after each entry. 

     

    If you currently have a list in your worksheet, go back to the worksheet and select the list.  

     

    In this example, we will enter the two-character State abbreviations:

    AL, AK, AZ, AR, CA, CO, CT, DE, DC, FL

    Step 7
  8. Click the OK button.

    Step 8
  9. Click the drop down menu

    Step 9
  10. Select the state abbreviation.

    Step 10
  11. Click the drop down menu

    Step 11
  12. Select the state abbreviation.

    Step 12
  13. Click the drop down menu

    Step 13
  14. Select the state abbreviation.

    Step 14
  15. Click the drop down menu

    Step 15
  16. Select the state abbreviation.

    Step 16
  17. Continue selecting state abbreviations from the list.

    Step 17

After completing this topic, you are able to validate data from an existing list.