how to make a drop down list in google sheets

In a web browser, edit the List Of Items in the text box to the right of the Criteria field ( Figure A). In the Google Sheets Android app, tap the three vertically-arranged dots menu in the upper-right, then tap Data Validation.ģ.

In a web browser, choose Data | Data Validation. Click or tap to select the cell or cells with the data validation setting you wish to change.Ģ. SEE: Google Sheets: Tips every user should master (TechRepublic) How to edit a manually entered drop-down list in Google Sheetsġ. Note: You may edit a drop-down list either in Google Sheets in a desktop-class web browser or in the Google Sheets app on Android. In either case, you will first need to open the Google Sheet, and you’ll also need to have edit access to the sheet and cells you wish to change. The following steps cover how to edit a manually entered list of data, as well as how to modify a list created from the contents of a range of cells. Since Google Sheets includes two ways to make a drop-down list, the method you use to edit the drop-down options will vary. Regardless of what you use a drop-down list for–people, places, or things–you may want to modify the offered options at various points in time. For example, you might need to add a new product, service, or option, or you may need to remove an option that is no longer needed. Sometimes drop-down list options need to change. Microsoft adds Copilot AI productivity bot to 365 suiteĦ best alternatives for 2023 (Free & Paid) To learn how to add data validation to one or more cells, see: How to create a drop-down list in Google Sheets. Whether you use Google Sheets in a desktop-class web browser or in the Google Sheets mobile app on Android or iOS, you get the benefit of fast and accurate data entry.

Select a cell, choose an item from the list, and continue on to your next task. For more info, visit our Terms of Use page.Ī drop-down list helps speed entry and standardize data in a Google Sheet. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Learn how to change the drop-down options in Google Sheets, edit list items manually, or change the contents of a range of cells. How to edit a drop-down list in Google Sheets

How to make a drop down list in google sheets