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.