Advanced Excel Data Validation and Drop Down List

By following following instructions you can validate your data easily

1-Select one or more cells or entire row or column to validate.
2-On the Data tab, in the Data Tools group, click Data Validation.
3-On the Settings tab, in the Allow box, select List, select date or whole number etc.
4-In the Source box, type your list values, separated by commas or you link them as well, or for whole number and date you have set the maximum and minimum criteria as well.
5-You can also write message in the selected cell in which you want data validation.
6-You can also change the error message by writing your own in data validation bar.

Make sure that the In-cell drop down check box is selected.

By doing this you can easily apply data validation in your desired result.

[raheel]

Very well, also shared organization skills.