Tips, Tricks, and Answers

The following articles are available. 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.