Skip to main content
Français (Canada)

How to filter a report list?

Updated

Find out more about opening CVS files here

From Excel

Use filters to temporarily hide some of the data in a table, so you can focus on the data you want to see.

Filter a range of data

  1. Select any cell within the range.

  2. Select Data > Filter.

    Filter button

  3. Select the column header arrow Filter arrow.

  4. Select Text Filters or Number Filters, and then select a comparison, like Between.

    Number Filters Between

  5. Enter the filter criteria and select OK.

    Custom AutoFilter dialog box

Filter data in a table

When you put your data in a table, filter controls are automatically added to the table headers.

An Excel table showing built-in filters

  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.

    Filter Gallery

  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.

From Google Sheet

You can sort data in alphabetical and numerical order, or use filters to hide data you don't want to see.

Sort data in alphabetical or numerical order

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the group of cells you'd like to sort.
  3.  If your sheet includes a header row, freeze the first row.
  4. Click Data and then Sort range and thenAdvanced range sorting options.
  5. If your columns have titles, click Data has header row.
  6. Select the column you'd like to be sorted first and choose a sorting order. 
    • To add another sorting rule, click Add another sort column.
  7. Click Sort. 

Sort an entire sheet

  1. On your computer, open a spreadsheet in Google Sheets.
  2. At the top, right-click the letter of the column you want to sort by. 
  3. Click Sort sheet A to Z or Sort sheet Z to A.

Filter your data

Important: When you add a filter, anyone with access to your spreadsheet will see the filter too. Anyone with permission to edit your spreadsheet will be able to change the filter.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a range of cells.
  3. Click Data and then Create a filter.
  4. To see filter options, go to the top of the range and click Filter Filter.
    • Filter by condition: Choose conditions or write your own. 
    • Filter by values: To hide data points, uncheck the box next to the data point and click OK. 
    • Search: Search for data points by typing in the search box. 
    • Filter by color: Choose which text or fill color to filter by. You can filter by conditional formatting colors, but not alternating colors. 
  5. To turn the filter off, click Data and then Remove filter.

LEARN MORE HERE.

Related articles