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
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
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