Sort & filter your data

Important:

• When you add a filter, anyone with access to your spreadsheet will find the filter too. Anyone with permission to edit your spreadsheet will be able to change the filter.
• The “Create a filter” option is unavailable under certain conditions. Learn more about these conditions.
• Your filter settings are saved, ensuring consistent filtering even if the data you filter on is removed. To reset filter settings, you can remove the filter from your data range.

1. On your computer, open a spreadsheet in Google Sheets.
2. To create a filter, select an option:
   • Select a range of cells, then click Data Create a filter.
   • Right click on a cell or a range of cells, then click Create a filter.
   Learn why ”Create a filter” is unavailable
   The option to “Create a filter” can be unavailable due to:

   • Formatting
     • Check for any merged cells or hidden rows or columns in the sheet. Try to unmerge the cells and unhide the rows or columns.
     • Check for any conditional formatting applied to the sheet.
       1. Go to Format.
       2. Select Conditional formatting.
          • Make sure there are no rules applied.
     • Data validation
       • Check for any data validation rules applied to the sheet.
         1. Go to Data.
         2. Select Data Validation.
            • Make sure there are no rules applied.
     • If none of the above solutions work, you might not have access. To get access:
       1. Create a copy of the sheet.
       2. Check if the filter option is enabled in the copy.
          • If it is, you can use the copy of the sheet instead.
3. To find the filter options, go to the top of the range and click Filter .
   • Filter by condition: Choose conditions or write your own custom formulas.
     Custom formula examples

     Find unique values within a data range

     • Select Custom formula is
     • Type =COUNTIF(data_range, data_range)=1

     Find text matching “Good” or “Great” within a data range

     • Select Custom formula is
     • Type =OR(REGEXMATCH(data_range, "Good"), REGEXMATCH(data_range, "Great"))
     • You can filter cells that have valid or invalid data validation rules.
   • Filter by values: To hide data points, uncheck the box next to the data point and click OK.
     • To create a filter and filter by cell value, right click on a cell then click Filter by cell value.
   • 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.
4. To remove the filter, select an option:
   • Click Data Remove filter.
   • Right click on any cell then click Remove filter.

Once filtered, at the bottom right users can find the number of rows being displayed out of the total rows in the table.

1. On your computer, open a spreadsheet in Google Sheets.
2. Click Data Create filter view.
3. Sort and filter the data.
4. To save your filter view, at the top right, click Save View.
5. Click Save.