Question

Define the filter option in excel

Answer 1

Answer:

The basic Excel filter (also known as the Excel Autofilter) allows you to view specific rows in an Excel spreadsheet, while hiding the other rows. When the Excel autofilter is added to the header row of a spreadsheet, a drop-down menu appears in each cell of the header row.

Answer 2

Answer:

The basic Excel filter (also known as the Excel Autofilter) allows you to view specific rows in an Excel spreadsheet, while hiding the other rows.

When the Excel autofilter is added to the header row of a spreadsheet, a drop-down menu appears in each cell of the header row. This provides you with a number of filter options that can be used to specify which rows of the spreadsheet are to be displayed.

This page describes how to use the autofilter in current versions of Excel (2007 and later). If you have Excel 2003, see the Excel 2003 Autofilter page.

Activating the Excel Autofilter

To apply the Excel autofilter:

First click on the range of cells that you want to filter.

Excel should automatically detect the entire data range when applying the autofilter. However, if the range of cells that you want to filter has missing rows or columns of data, Excel will not select all the data, so you may need to manually select the range of cells that you want to apply the filter to.

Explanation: