Apply a named filter

Apply a named filter

To use or apply a named filter,

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

Note: On applying a named filter, the file URL becomes specific to that particular filter. This URL can be shared with collaborators who wish to apply the same filter.

    • 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 ...

    • 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 ...

    • Manage named filters

      Rename, delete, and reorder named filters using the Manage Named Filters option. Click on the dropdown arrow in the filter icon  in toolbar and choose Manage Named Filters. In the Manage dialog, hover the mouse pointer over the filter of choice and ...

    • 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 ...

    • 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 ...