Nokia C3: use of autofilters in microsoft office excel

use of autofilters in microsoft office excel
Hi, I am using Microsoft Office Excel 2007 on my windows 7 system.I am new to this application. I am preparing a work sheet regarding the products information of a shopping mall. I want to know how I can use filter like auto filter and dropdown list in Microsoft office Excel. Why is it required to use filter. Please somebody tell me how to activate the autofilter in Microsoft office excel 2007
Reply With Quote
#2
Old 06-04-2011
Badrunath Badrunath is offline
Member

Join Date: Jun 2009
Posts: 1,519
Re: use of autofilters in microsoft office excel
Microsoft office Excel is the most popular application that is used in office, banks and other working places to store information or data in a very well and sorted manner so that it makes the search easy. Filter enables the user to view only that record which contains the value specified, it hides the other records temporarily. Auto filter is the filtering tool which is when applied in a data list, the column heading transformed to drop down list box.
Reply With Quote
#3
Old 06-04-2011
MahaGuru's Avatar
MahaGuru MahaGuru is offline
Member

Join Date: Nov 2008
Posts: 1,526
Re: use of autofilters in microsoft office excel
Auto filter when applied hides the other records and only displays the particular record whose value is specified. When auto filter is applied to any column, it is modified to drop down list boxes. Each drop down list has the unique values. When you select a value from the drop down list box, the data will be filtered and will display the rows corresponding to the field value selected by you.
Reply With Quote
#4
Old 06-04-2011
GeforceUser GeforceUser is offline
Member

Join Date: Mar 2009
Posts: 1,364
Re: use of autofilters in microsoft office excel
To enable the auto filters you need to place the active cell anywhere in the data list or within header row. Click on “data”and then select filter AutoFilter. Now that you have applied autofilter a dropdown arrow appear at the top row. Now select a value also known as field value to filter. You can also select additional filter values from different fields if you desire to do so. This is how you can use auto filters and drop down list.
Reply With Quote
#5
Old 06-04-2011
DotNetUser DotNetUser is offline
Member

Join Date: Nov 2008
Posts: 1,187
Re: use of autofilters in microsoft office excel
You can also use additional filter with auto filters. You can click the arrow that is in the present in the heading in any column to enable filter. To disable auto filter choose “All” from the AutoFilter drop-down list in the preferred column. Repeat again the same step if you want to remove any additional filter. you can also use the alternate way like you can choose “data” then select “filter”then “show and click”all”
Reply With Quote