excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

ExcelTips
Home Tips
Pet Tips
Word2007 Tips

Newest Tips

Negative Elapsed Times

Specifying the Number of MRU Files

Changing Data Series Ordering

Seeing How Excel Evaluates Formulas

Highlighting a Cell if It Contains Specific Text

Filling Shapes with Pictures

Creating a List of Worksheet Formulas

 

Tips, Tricks, and Answers

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

Extracting Records from a List that Match a Criterion. If you have a bunch of data in an Excel worksheet, you may need to work with just a subset of that data. One way to do that is to extract just the data that meets a particular criterion you specify. Excel makes this easy to do using the advanced filtering capabilities of the program.