Microsoft Office Tutorials and References
In Depth Information
Troubleshooting The appearance of buttons and groups on the ribbon changes depending
on the width of the program window. For information about changing the appearance of
the ribbon to match our screen images, see “Modifying the Display of the Ribbon” at the
beginning of this topic.
Tip When a column contains several types of data, the filter command becomes Number
When you click a filtering option, Excel displays a dialog box in which you can define
the filter’s criteria. As an example, you could create a filter that displays only dates
If you want to see 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 see, 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. Using the Top 10 AutoFilter dialog box, you can find your
top 10 salespeople or identify the top 5 percent of your customers.
Excel 2010 includes a new 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 typing a character string
in the Search box. As you type 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.