What is Data Validation in Excel?
We use Data validation to restrict or validate the entry in a worksheet or workbook. Through data validation we can allow to user for the specific entries in the data. For example in a range we want to enter only date and other then entry we want to restrict we can validate the range only for date entry.
How to use data validation?
To understand how to use data validation, let's take an example:-
Original Question:-
We want validate a range, in which we will able to enter only 1,2,3 and letters r & d.
Following is the snapshot of range in which we will apply data validation.
We need to follow the below steps:
In this way we can work with data validation list without drop down list.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.