Data Validation In Microsoft excel

Ever been hounded by the thought of data entry errors. Simple Mistakes and even plain simple mistakes can wreck havoc on the data analysis.

If you have a defined number of options to choose from and enter then the data validation option comes to the rescue.

Example:

Entering the Date, Month and Year in 3 different Columns.

Date: Can be made to choose from 1-31

Month: Can be made to choose from Jan-Dec

Year: Any logical defined Range can be Taken.


How To:

Navigate to the Data Tab>Data Validation

Thats it. This way you restrict users to select values between the defined range only.

There are a number of other options also.

Please ping me for any specific details you might require.

Thanks Again.