Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 06-04-2011
Member
 
Join Date: Mar 2011
Posts: 49
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
Member
 
Join Date: Jun 2009
Posts: 1,518
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
Member
 
Join Date: Nov 2008
Posts: 1,514
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
Member
 
Join Date: Mar 2009
Posts: 1,360
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
Member
 
Join Date: Nov 2008
Posts: 1,185
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
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "use of autofilters in microsoft office excel"
Thread Thread Starter Forum Replies Last Post
location of Microsoft.Office.Interop.Excel.dll elander Office Setup 1 01-10-2012 11:48 AM
Error in the Microsoft Office Excel previewer Althea Windows Software 5 28-04-2011 05:56 AM
Microsoft Office Excel 2003 collioure_bee Windows Software 2 12-10-2009 06:05 PM
A Data Table in Microsoft Office Excel kattman Guides & Tutorials 7 29-04-2009 05:58 PM
How To Add the calculator to Microsoft Office Excel 2007 Conrad Tips & Tweaks 0 08-12-2008 05:04 PM


All times are GMT +5.5. The time now is 10:22 PM.