Add filter to spreadsheet column

You can filter data by using several types of filters. The proper options in accordance of the data type help you quickly decide which filter you use.

Steps

To filter text

  1. Select a range of cells containing text data.
  2. Click Data > Filter > Filter and a Filter button will be displayed in each field name.
  3. Click the filter button  for the text field and then select Text Filters > Does Not Contain.
  4. Type text in the text box with the condition Text to Exclude in the Search Condition section on the Custom AutoFilter dialog.
  5. Click the OK button to hide rows that you typed text to exclude.

To filter numbers

  1. Select a range of cells containing numeric data.
  2. Click Data > Filter > Filter and a Filter button will be displayed in each field name.
  3. Click the filter button  for the number field and then select Number Filters > Top 10.
  4. Set '5' in the second control on the Optional AutoFilter dialog.
  5. Click the OK button to display up to 5 items only.
    By default, the value is set to 10 to filter best items by up to 10.

To filter dates or times

  1. Select a range of cells containing date data.
  2. Click Data > Filter > Filter and a Filter button will be displayed in each field name.
  3. Click the filter button  for the date field and then select Date Filters > Last Week.
    Date within last week based on the current time of the system settings are only shown. If the field does not contain date within last week, all the rows will be hidden.

 

When you select the AutoFilter option, the filter conditions in the active database are displayed. To display only the data that satisfy the specified conditions, select the conditions of your choice from the condition list.

Steps

To filter data

  1. Select a range of cells filter data.
  2. Click Data > Filter > Filter and a Filter button will be displayed in each field name.
  3. Click the filter button  for the field you want to apply filter to.
  4. In the filter list, click the check box in front of the items you want to hide to deselect them, and click Set.
  5. Only the selected data will be displayed on screen.

  6. To display all data on screen, click Data > Filter > Clear, or click the filter button for the field, and then select Release Filter.
  7. To clear the AutoFilter option, click Data > Filter > Filter.
Was this article helpful?
0 out of 0 found this helpful