Microsoft Office Tutorials and References
In Depth Information
Limiting data that appears on your screen
If you want to display the highest or lowest values in a data column, you can create a Top
10 filter. Choosing the Top 10 command from the menu doesn’t just limit the display to
the top 10 values. Instead, it opens the Top 10 AutoFilter dialog box. From within this
dialog box, you can choose whether to show values from the top or bottom of the list, define
the number of items you want to display, and choose whether the number in the middle
box indicates the number of items or the percentage of items to be shown when the filter
is applied. By using the Top 10 AutoFilter dialog box, you can find your top 10 salespeople
or identify the top 5 percent of your customers.
Excel 2013 includes a capability called the search filter , which you can use to type a search
string that Excel uses to identify which items to display in an Excel table or a data list. To use
a search filter, click a column’s filter arrow and start entering a character string in the Search
box. As you enter the character string, Excel limits the items displayed at the bottom of the
filter panel to those that contain the character or characters you’ve entered. When the filter
list’s items represent the values you want to display, click OK.
Search JabSto ::




Custom Search