Drop down list in Excel

For example, in collecting personal information for record keeping, how do I ensure that user can enter only one of the following 4 values against Marital Status - Single, Married, Separated and Divorced?

To do it in Excel, here is the answer:

a) Select the field for Marital Status input. Under "Data" tab, click Data Validation -> Data Validation.

excel drop down list

b) Select "List" for Allow field and enter "Single, Married, Separated, Divorced" in Source field so that input is restricted to one of these 4 values. Click OK.

A "down arrow" appears to the right side of the "Marital Status" field indicating that it has a drop down list.

excel drop down list

c) If user inputs a value that is not part of the drop down list, error message appears asking user to retry or cancel.

excel drop down list


You can find similar Excel Questions and Answer hereunder

1) Vlookup to return max value from multiple hits in Excel

2) How can I edit data in multiple WorkSheets together?

3) How do I update my DropDown list whenever the sheet is activated?

4) Generate a list of unique values in Excel

5) How can I identify cells with Circular Reference in a WorkSheet?

6) Here an explanation about the file dialog and how to control in with VBA

7) Sumifs with date range as criteria in Excel

8) How can I create dependent drop down lists?

9) How do I add a shape using VBA?

10) How to control forms in Excel VBA


Here the previous and next chapter