Apply Filter

Apply Filter

To apply filter:

    1. Select the column or range of cells to be filtered.

    2. Click Data> Filter or use the Filter icon  from Toolbar or right click on the selected range and select Filter from the context menu.

    3. Choose the required filtering criterion. The available options include the following:

  • Cell value

  • Cell color

  • Text color

Once the filter is applied, you'd see a drop down on the cell. Click on it, and filter only what's needed.


​

Note: Zoho Sheet's filters are collaboration friendly. If you filter your range, only you can see the applied filter, and other collaborators can keep working, undisturbed.

    • Related Articles

    • Create a named filter

      Once you've applied a filter on a range, Zoho Sheet allows you to save it for quick access later on. Select the required filter range and click on the Filter icon in the toolbar or go to Data > Filter. Apply the required filter conditions by clicking ...

    • Set as document filter

      Setting a filter as the document filter means the specified filter will be applied to all the users who are opening the spreadsheet for the first time until the filter is either removed or replaced with another. The published version of the file will ...

    • Apply a named filter

      To use or apply a named filter, Click on the dropdown arrow on the   icon in the toolbar and choose Named Filters. From the list of named filters, choose the filter you wish to apply. The filter will be applied on the specified range saved along with ...

    • Filter Deals

      When there are lot of records in the Deals module, using filters will help find the required set of records easily. There are various set of advanced filters available such as: Time based filters, based on activities carried out,  deal stage, email ...

    • Filter users

      Advanced filters can be used to generate a list of specific users, and perform bulk actions on them.  Advanced filter  Sign in to the Zoho One Admin Panel. Click on Users. Click  in the top-right corner. Set the filtering criteria, then click Apply.