Wednesday, June 29, 2011

Filter option In Microsoft Excel 2010

Selecting values from a list and searching are the quickest ways to filter. When you click the arrow in a column that has filtering enabled, all values in that column appear in a list. The following illustration shows three methods for quickly filtering data. Excel has introduced this feature since 2003 version.

To Filter using filter button :

1) Click on Filter Button under Data tab in Sort & Filter Group. 

 Filtered data displays only the rows that meet criteria that we specify and hides rows that we don't want displayed. After we filter data, we can copy, find, edit, format, chart, and print the subset of filtered data without rearranging or moving it. Filters are additive, which means that each additional filter is based on the current filter and further reduces the subset of data that is shown. 

Note: If we use find box in filtered data, it will search in the displayed data only not whole data.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More