O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Finding and Filtering Data in a List

When working with lists, you can use the Find shortcut (Ctrl+F) to search for any value in the list. That technique is useful if you want to jump quickly to a specific unique value in the list. More often, however, you'll want to extract details from a list instead of simply jumping to a single record. In that case, use filters to hide all records except those that match criteria that you specify. In a list that contains hundreds or thousands of rows, defining a filter helps you see a small number of related records together, making it easier to compare data and identify trends.

For example, in a list of daily high, low, and closing stock prices that includes data for many companies, you might want to see ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required