How to create filters in Excel

Configurare noua (How To)

Situatie

You need to apply filters on different columns in excel.

Solutie

Pasi de urmat
  1. Select any cell within the range.

  2. Select Data > Filter.
  3. Select the column header arrow Filter 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 Filter drop-down 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 Filter drop-down arrow changes to a Applied filter iconFilter icon. Select this icon to change or clear the filter.

Tip solutie

Permanent

Voteaza

(35 din 64 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?