Filter data in a range

Filter a range of data

  1. Choose any cell within the range.
  2. Pick Data > Filter.
  3. Pick the column header arrow.
  4. Choose Text Filters or Number Filters. Then, pick a comparison, like Between.
  5. State the filter criteria and press OK.

Filter data in a table

After adding your data in a table, filter controls are instantly inserted to the table headers.

An Excel table showing built-in filters
© Microsoft 2019
  1. Pick the column header arrow for the column you want to filter.
  2. Uncheck (Select All). Next, confirm the boxes you want to display.
  3. Click OK. The column header arrow switches to a Filter icon. Choose this icon to edit 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.

Leave a Reply

%d bloggers like this: