Posts

Showing posts from December, 2015

How to Use Data Validation in MS Excel

Image
MS Excel has huge number of users over the world and these numbers are increasing day by day because every time it comes with new features. People use the excel sheet to maintain the data in a good manner. Have you ever tried to apply the validation on the cell? If your answer is no, then read this blog to know about validation option in MS Excel.

Suppose, you want to set the validation (restriction) on a cell that, when someone is trying to enter a data which is more than 15 characters or against the validation then, it will throw an error in the screen to warn the user.


Steps to add validation:

Step 1: Click on the Data tab. Unser the Data Tools option, Data Validation option is available.


Step 2: Now select the cell which you want to validate. Click on the Data Validation option. When you will click on this option then, a window will appear on the screen with the different validation option. This window looks like this:

You can see the different validation options in this window: Sett…