---
schema_version: "1"
id: 8cdd09b531b62f57f7d8b5491cf86a99b664f3618bd33b9ee813454a0517095e
title: Use Data Validation in Spreadsheets
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/quip_data_validation.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.quip_data_validation.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e435f440867fbce44cfbb77e7e1e969a93e436820d3e80c3368c8067eb45cdb3
description: Apply data validation to a cell or series of cells to keep data in your spreadsheets consistent.
products:
  - Quip
  - Cross Cloud
release: "264"
---
# Use Data Validation in Spreadsheets

Apply data validation to a cell or series of cells to keep data in your spreadsheets consistent.

### 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>

From the Data menu, select **Data Validation**. Or, right-click to open the cell menu, and select **Data Validation**.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><colgroup><col style="width:50%"> <col style="width:50%"></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Select From List</td><td class="slds-cell-wrap" style="vertical-align:top;">Users select a cell value from a dropdown list. Enter and sort the values for the dropdown list, and choose a color to apply to the cell for each value.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Select From Range</td><td class="slds-cell-wrap" style="vertical-align:top;">Users select a cell value from a dropdown list that references a range of data in the spreadsheet. Select the data range that you want to reference from the spreadsheet.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Number</td><td class="slds-cell-wrap" style="vertical-align:top;">Users can enter only numbers in this cell. To specify a range, choose an operation and enter an argument.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Email</td><td class="slds-cell-wrap" style="vertical-align:top;">Users can enter only email addresses in this cell.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Text</td><td class="slds-cell-wrap" style="vertical-align:top;">Users can only enter text that matches, contains, or doesn’t contain a specified text string. To define the text string, choose an operation and enter an argument.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Date</td><td class="slds-cell-wrap" style="vertical-align:top;">Users can enter only dates. To specify a date range, choose an operation and enter an argument.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Attachment</td><td class="slds-cell-wrap" style="vertical-align:top;">Users can add only attachments to the cell.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">URL</td><td class="slds-cell-wrap" style="vertical-align:top;">Users can enter only URLs in the cell.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Checkbox</td><td class="slds-cell-wrap" style="vertical-align:top;">Format the cell as a checkbox.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Person</td><td class="slds-cell-wrap" style="vertical-align:top;">Users can only @ mention people in the cell.</td></tr></tbody></table>

- **[Use Dropdown Lists in Spreadsheet Cells](https://help.salesforce.com/s/articleView?id=xcloud.quip_dropdown_lists_in_spreadsheet_cells.htm&release=264.0.0&type=5)**  
    Create a dropdown list for a cell or series of cells to let users choose from a group of defined values when entering data.