Data Validation

Tips, Tricks, and Answers

The following articles are available for the 'Data Validation' topic. Click the article's title (shown in bold) to see the associated article.

Creating a Single-Use Drop-Down List
Data validation can be a great tool for entering data in a worksheet. One of the ways this entry can occur is through the use of a drop-down list, described in this tip.

Creating Your Own Pop-Up Help Information
Want to have a small help screen pop up when a user selects a particular cell? This can be done by using data validation, as described in this tip.

Making Sure Duplicate Names Aren't Entered
When inputting information into a worksheet, you may need a way to limit what can be entered. This scenario is a prime candidate for the Data Validation capabilities of Excel, but you aren't limited to them.

Using Data Validation to Limit Data Entry
When creating a worksheet, you may need to limit what can be entered into a particular cell. Using data validation you can easily limit input to numeric values within a certain range.