Thursday, March 24, 2011

Filter In Microsoft Excel

Filters are used to take the data that is required and remove all the unnecessary data. We can create filters by selecting columns and rows. It will give an arrow mark beside the field heading and will give the list of data in the rows below it. we see the data just by selecting any one or more or all of the row fields under it. 

Steps to create a Filter in Microsoft Excel
1) Select the data on the worksheet 

2) Click on Filter Under Data Tab on Sort and Filter Ribbon. 

3) We will see an arrow Beside the data in the first row in the first column. Click on that to see the available rows that we want them to see on the sheet. Check the options that we want to see. 

4) Click OK to see the filtered data. 


Post a Comment

Search This Blog


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