You are here:
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.

Use more general search terms.
Select fewer filters to broaden your search.
You are here:
Create a dropdown list for a cell or series of cells to let users choose from a group of defined values when entering data.
| Available in: Quip desktop app, Quip iOS mobile app, and Quip on web |
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.

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.