excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Beauty Tips
ExcelTips
Health Tips
Legal 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

 

Advanced Filtering

Tips, Tricks, and Answers

The following articles are available for the 'Advanced Filtering' topic. 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.