Data Validation in Excel
Friday, November 21st, 2008Using Data Validation to input data into Excel cells can improve your productivity substantially. Surprisingly few people use the data validation feature in Excel!
Data validation is the simple process of inputting data into Excel cells using defined criteria. For example, let’s say, you need to enter the names of the employees in an Excel worksheet regularly. Why think about the spellings or try to remember all the names? You create a list and then arrange the cells in such a way that you can select the names from a drop down list. Similarly, let’s assume you need to enter the prices of items that you sell or the salary of the employees. Create a list!