excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Beauty Tips
Excel2007 Tips
Health Tips
Word2007 Tips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 

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.