Use Filter for your data in Excel

Use Filter for your data in Excel
Last Updated on 25/02/2024
Reading time: 2 minutes

Filter is one of the most useful and powerful tools in Excel

  1. You keep visible only some rows

    When you apply a criterion to a column, only the rows with this criterion are visible

  2. Data are not deleted

    When a filter is applied to a criterion, the rest of the rows are not deleted. They are just hidden

How to visualize the filters?

You know that the filter is ON when you see arrows on the headers of your table.

Filter ON

Activate the Filter

  1. Select one of the cells of your table
  2. Activate the filter in the Data > Filter
Menu Filter Excel
  1. Now you see arrows in the header of your table
The arrows on the headers mean you have filter
  • You can also activate the filter with the shortcut Ctrl + Shift + L

Apply a filter for one criterion

Working with the filter is very easy. To select only the rows for the country Germany (DE), you must do the following steps

  1. Go to the header of the column where you want to apply the filter
  2. Click on the arrow
  3. Uncheck all items (Select All)
  4. Select only the item you want (in this case, Beverages)
Apply Filter on a column Excel
  • Only the rows with this criterion are visible. The other rows are simply hidden.
  • You know when your table is filtered when the row numbers are colored in blue. As you can see, only the row numbers of the rows containing your criterion are visible.
Excel row number are blue when a filter is applied

Apply a filter on many columns

You can filter many columns. There is no limitation. For instance, we want to select the following values

  1. Male in column Gender
  2. DE and AT in column Country
  3. Beverages in the column Category
Filter on many columns

How many rows are filtered?

When you activate a filter, you can see how many rows are returned by looking at the bottom left in the status bar

Number of rows filtered

FILTER function

If you use Excel 365 or Excel 2021, you can filter dynamically your data with the FILTER function

Remove filters

Removing filters is also important. You can remove them by clicking on this option

Remove all the filters

Leave a Reply

Your email address will not be published. Required fields are marked *

Use Filter for your data in Excel

Reading time: 2 minutes
Last Updated on 25/02/2024

Filter is one of the most useful and powerful tools in Excel

  1. You keep visible only some rows

    When you apply a criterion to a column, only the rows with this criterion are visible

  2. Data are not deleted

    When a filter is applied to a criterion, the rest of the rows are not deleted. They are just hidden

How to visualize the filters?

You know that the filter is ON when you see arrows on the headers of your table.

Filter ON

Activate the Filter

  1. Select one of the cells of your table
  2. Activate the filter in the Data > Filter
Menu Filter Excel
  1. Now you see arrows in the header of your table
The arrows on the headers mean you have filter
  • You can also activate the filter with the shortcut Ctrl + Shift + L

Apply a filter for one criterion

Working with the filter is very easy. To select only the rows for the country Germany (DE), you must do the following steps

  1. Go to the header of the column where you want to apply the filter
  2. Click on the arrow
  3. Uncheck all items (Select All)
  4. Select only the item you want (in this case, Beverages)
Apply Filter on a column Excel
  • Only the rows with this criterion are visible. The other rows are simply hidden.
  • You know when your table is filtered when the row numbers are colored in blue. As you can see, only the row numbers of the rows containing your criterion are visible.
Excel row number are blue when a filter is applied

Apply a filter on many columns

You can filter many columns. There is no limitation. For instance, we want to select the following values

  1. Male in column Gender
  2. DE and AT in column Country
  3. Beverages in the column Category
Filter on many columns

How many rows are filtered?

When you activate a filter, you can see how many rows are returned by looking at the bottom left in the status bar

Number of rows filtered

FILTER function

If you use Excel 365 or Excel 2021, you can filter dynamically your data with the FILTER function

Remove filters

Removing filters is also important. You can remove them by clicking on this option

Remove all the filters

Leave a Reply

Your email address will not be published. Required fields are marked *