---
schema_version: "1"
id: f3035178c1e4246b3f7e883ddf7ad287270b9979de152ccbf2a046e534fec911
title: Use Dropdown Lists in Spreadsheet Cells
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/quip_dropdown_lists_in_spreadsheet_cells.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.quip_dropdown_lists_in_spreadsheet_cells.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: cedba37252dea3d1843e4d1392e41d5976c1d4133157d69932083741a363ffe3
description: Create a dropdown list for a cell or series of cells to let users choose from a group of defined values when entering data.
products:
  - Quip
  - Cross Cloud
release: "264"
---
# Use Dropdown Lists in Spreadsheet Cells

Create a dropdown list for a cell or series of cells to let users choose from a group of defined values when entering data.

### 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. Select the cell or cells where you want to add a dropdown list.
2. From the Data menu, select **Data Validation**. Or, right-click to open the cell menu, and select **Data Validation**.
3. From the Type dropdown, choose **Select from List**.
4. Define the criteria for the dropdown.
5. Click **Apply**.

A dropdown arrow appears in each cell. If users enter a value in the cell that doesn’t match a value in the dropdown list, an error appears. To remove a dropdown list from a cell, from the Data menu, select **Data Validation**, and then click **Remove Validation**.