How to add Data Validation in MS-Excel

 

In MS-Excel, we can type anything like numbers, text, date etc. in a cell or range but if we want to restrict a cell or range to have a specific data, we can use data validation.

For Instance:

Let suppose we have a data as shown in a following screenshot,

 

In this data we want to apply the restriction that we cannot write anything other than given 4 Standard Reasons in the selected range. 

Now, select the cell or range where data validation is required to be added, go to the Data menu and click on Data Validation option (Shortcut key: Alt + A + V) and then select the Data Validation as shown in the following screenshot.

By an option, the following dialog box will get appeared in which, select List option from a dropdown and then in the field of Source, enter the reference of range wherein the standard reasons are mentioned and click on OK.

Now, while editing cell or range wherein the Data Validation added, we will get a dropdown in every cell to choose 1 of the 4 given standard reasons to fill the cell and if we try to write anything other than these 4 reasons then Excel will show an error message.

 

If you have any kind of challenge or you want to learn about any other Function/Option which is not covered or you want me to add more into the previously covered topic, please comment. I will be happy to take your queries or suggestions.