Filter

You can filter data and display only the required data. Depending on the conditions, data in the active database are filtered.

Display Data above Average

Perform the following to display data above average.

1. Select a range of cells with numbers to apply filter.
2. Click Data-Filter.
3. Click the Filter Expand icon.

   

4. Click Number Filters-Above Average from the menu.
   Date above average will be displayed, data at average or below will be hidden.

   

Exclude Text Starting with Particular Letter

Perform the following to exclude text starting with particular letter.

1. Select a range of cells with text to apply filter.
2. Click Data-Filter.
3. Click the Filter Expand icon.

   

4. Click Text Filters-Custom Filter from the menu.
5. Select Start Text to Exclude from the list and enter the letter in the input box of the Custom AutoFilter dialog box.

   

6. Click OK.
   Data except for those text start from the letter entered in the Custom AutoFilter dialog box will be displayed.

   

Show All Filtered Data

Perform the following to clear filter.

1. Click the Filter Expand icon at the filtered cell.
2. Click Release Filter from the menu.
   Or you can also click Select All then OK to release the filter.

Sort Data in Ascending Order

Perform the following to sort data in the ascending order.

1. Click the Filter Expand icon at the filtered cell for the basic column to be sorted out.

   

2. Click Sort A to Z from the menu.
   Data will be organized in the ascending order and the Expand Filter icon changes to the Ascend icon.

   

Note

Number Filters

You can filter data by values such as numbers or criteria (average, top 10, etc.)

Text Filters

You can filter data by text including or beginning with a specific character or other criteria.

You can filter data and display only the required data. Depending on the conditions, data in the active database are filtered.