use of autofilters in microsoft office excel

[fANIBHUSAN]

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

[Badrunath]

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.

[MahaGuru]

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.

[GeforceUser]

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.

[DotNetUser]

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”