excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Car Tips
Legal Tips
Money Tips
WordTips (menu) Tips

Newest Tips

Controlling How Excel Adjusts Capital Letters

Numbers Mysteriously Divided by 100

Counting Unique Names

Copying Filtering Results

Centering Your Worksheet Data

Displaying Comment Boxes where You Want Them

Turning the Formula Bar On and Off

 

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.