Data validation in the drop down list

We will learn how to make a drop down list and validate the data you enter. It can be quite helpful when organizing your data.

Enter the similar data I've entered and choose the cell where you want a drop down list.

Click Data in the menu.

Click Data Validation and choose Data Validation.

In the new Data Validation window choose List in the the Allow field.

Click in the Source field and select the cells containing the data you want to have in the drop down list.

Click the Error Alert tab.

Enter the error message title and the error message.

Click the drop down list cell ...

... and select an entry.

Now write something random in the same cell...

... a window with the error message you entered previously should appear.