Question

when a filter paper is applied on a range of cells only the row that met is​

Answer 1

Explanation:

Filter a range of data

Select any cell within the range.

Select Data > Filter.

Filter button

Select the column header arrow Filter arrow .

Select Text Filters or Number Filters, and then select a comparison, like Between.

Number Filters Between

Enter the filter criteria and select OK.

Custom AutoFilter dialog box

Filter data in a table

When you put your data in a table, filter controls are automatically added to the table headers.

An Excel table showing built-in filters

Select the column header arrow Filter drop-down arrow for the column you want to filter.

Uncheck (Select All) and select the boxes you want to show.

Filter Gallery

Click OK.

The column header arrow Filter drop-down arrow changes to a Applied filter icon Filter icon. Select this icon to change or clear the filter.

Related Topics

Excel Training: Filter data in a table

Guidelines and examples for sorting and filtering data by color

Filter data in a PivotTable

Filter by using advanced criteria

Remove a filter

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.