Introduction: Data Validation is meant to ensure that user inputs correct type of information in the cell. The Data Validation can be achieved in the form of “Drop-down Lists” that make sure that user can only choose from a given set of values or using options like input being whole number, a decimal value, a date or something defined by a formula. The data validation menu … [Read more...]
Data Validation to Avoid Duplicate Values
Suppose you have a spreadsheet where you are entering a list of unique values, such as invoice numbers, customer names, etc. You don't want to duplicate any of the data, as this would cause problems down the road, but at the same time the list might be too large for you to manually verify that no duplicate values have been entered. You can use Data Validation to ensure that … [Read more...]
Drop Down Lists To Create Hyperlinks
As discussed in a previous tip, adding a drop down list to your worksheet allows the users of the worksheet to enter information in a neat, consistent format. The example in the previous tip emphasized the importance of having consistent information when summarizing information in a PivotTable. Another use is to store lists of information, which could be anything, but in … [Read more...]
Drop Down Lists Using Data Validation
Adding a drop down list to your worksheet allows the users of the worksheet to enter information in a neat, consistent format. For example, say your worksheet asks a user to input information that later will get summarized in a PivotTable. If the user doesn't enter the information consistently (i.e. spells out words some of the time, and abbreviates the rest), the … [Read more...]