Create a Spreadsheet Filter

Filter data in your spreadsheet. When you turn on filtering, you filter the view for everyone who’s a member of the spreadsheet.

Required Editions

Available in: Quip desktop app, Quip iOS mobile app, and Quip on web
  1. From the Data menu, select Turn on Filter.
  2. Select a single column, multiple columns, or a custom range within or across columns.
  3. Define filter criteria.
    • Equals shows only exact matches for the letters or word that you put in the value field.
    • Greater Than and Less Than show rows that are alphabetically before or after the letters or word that you put in the value field.
  4. Click Apply.

To remove individual filters, select the filter menu for the column that you want to stop filtering, and then select Remove Filter. To remove all filters, from the Data menu, select Turn off Filter.