---
schema_version: "1"
id: 60741cdcd605eef9af41bf9eb5511b6e9c988bdae1eb1465d5a568469dc2e108
title: Create a Spreadsheet Filter
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/quip_spreadsheet_filters.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.quip_spreadsheet_filters.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ff55368b0a5d9eaee6e0b16d51e4656f19062817f324140a23636c95681b9b20
description: Filter data in your spreadsheet. When you turn on filtering, you filter the view for everyone who’s a member of the spreadsheet.
products:
  - Quip
  - Cross Cloud
release: "264"
---
# 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Quip desktop app</strong>, <strong>Quip iOS mobile app</strong>, and <strong>Quip on web</strong></td></tr></tbody></table>

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