Video Filter Data By Using Autofilter. AutoFilter feature is based on data so there need some data in the worksheet first. Suppose you are a regular user then excel filters are not a strange thing for you.

The following example demonstrates this. Verwenden Sie den AutoFilter um einen Datenbereich in Excel 2010 zu filtern und erfahren Sie wie Sie Filter entfernen. Suppose you are a regular user then excel filters are not a strange thing for you.
The filter is helpful in filtering the particular data from the huge data.
Click the arrow in the column header to display a list in which you can make filter choices. Select the data that you want to filter On the Data tab in the Sort Filter group click Filter. AutoFilter feature is based on data so there need some data in the worksheet first. Then select the target column to add auto filter.