Data Validation in Excel – How to Use Data Validation Feature in Excel

Posted on 24 December 2009

Data Validation feature in Excel prevents invalid entries from being entered into a cell in a sheet. Data validation can be set up to work with numbers, text string, date / time or customized formula so that we can restrict the set of values that can be entered in a cell and also prevent wrong entries being made at the time of data entry. Data validation can also be used to create drop down lists so that the user ... Continue Reading

Comments (1)

Data Validation in Excel

Posted on 03 April 2009

Data Validation in Excel is a feature that allows you to control or restrict the type of data that you can enter in to a cell in a workbook. When used properly, data validation can help you prevent users from entering invalid values in an excel workbook. This reduces potential errors and can save you a lot of time. You can download an excel workbook with various examples of data validation in excel using simple, named lists and dynamic named ... Continue Reading

Comments (9)

5 easy ways to make data validation work for you

Posted on 06 September 2008

One of the easiest ways to add interactivity to your spreadsheets and dashboard is to use the data validation feature in excel. Data validation allows you specify a list of options that you want a cell to display as a drop-down. You may want to download the sample sheet here before we begin. To being creating a dropdown for a particular cell, select the cell and click Data -> Validation. In ... Continue Reading

Comments (2)