Video filter data in a range or table

Try it!

Use filters to temporarily hide some of the data in a table, so you can focus on the data you want to see.

Filter a range of data

1. Select any cell within the range.

2. Select Data > Filter.

   

3. Select the column header arrow .

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

   

5. Enter the filter criteria and select OK.

   

Filter data in a table

When you Create and format tables, filter controls are automatically added to the table headers.

1. Select the column header arrow for the column you want to filter.

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

   

3. Click OK.

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

Want more?

Filter data in a range or table

Filter data in a PivotTable