Data Validation in Microsoft Excel

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.

 

img1

 

We need to follow the below steps:

  • Select the range A1:D5
  • Press ALT + D + L shortcut key
  • From Settings tab click on Allow drop down & select List
  • In Source box enter “1,2,3,r,d”
  • Ensure unchecking the “In-cell dropdown”

 

img2

 

  • Click on Ok button
  • You will find no drop down list in selected cell.
  • User will not allow to enter any value except the number between 1 to 3 & characters ‘r’ & ‘d’ in range A1:D5

 

img3

 

  • If we try to enter other value then we will receive following error message

 

img4

 

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube