Have you ever found yourself scanning row after row in an Excel worksheet to pick out just the data you're interested in? Maybe you're looking for rows containing the name of a particular person, product, or company. Plowing through all of the irrelevant material takes time, especially if the worksheet contains hundreds or even thousands of entries.

If this sounds familiar, Excel has the answer in the form of the AutoFilter command. Filtering shows you just the data you want to see while temporarily hiding the rest. By defining different filters, you can compare data in multiple ways, so you can glean vital information without wasting vital time. Watch this demo to see how it works.

How to do it (text version):

• Filter a range
• Remove filters

Training course:

• All about AutoFilter

 Problems watching the video? Try our troubleshooting tips.