Data Validation

How to use data validation in Excel 2007
How to use data validation in Excel 2007: Entering correct data into Excel sheets is crucial to any work in calculations or analysis. Data validation provides an excellent tool to make data entry easy, accurate and quick. You can validate text, numbers, functions and custom functions using the data validation feature. Using lists, boundaries of numbers, text length limitations and even custom criteria, you can ensure that the data entry operator makes lesser mistakes. Also by providing visual messages you can guide the operator. Finally if the user makes a wrong data entry he gets an attention grabbing message which informs him about how to follow the data entry instructions and that the data he entered does not match the specified parameters!
Watch the training video below to understand quickly how the data validation is implemented in Excel:

Further reading:
Apply data validation to cells

One thought on “Data Validation

  1. Exactly that’s what I like to me at that time also happened Fortunately, I had exactly the same with the tablet and already had the problem (to read as it is sent). In conjunction with the Tablet of my father I have found the reset so#ulion&t8230;

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.