Filter data in a range or table (2024)

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.

   

   See Also

   3 Methods to Unhide All Sheets in Excel (& how to hide)Show/Hide — Blender ManualHow to Hide or Unhide Columns or Rows in Excel (with Shortcuts)Video: Manage drop-down lists - Microsoft Support

3. Click OK.

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