Learn how to change the drop-down options in Google Sheets, edit list items manually, or change the contents of a range of cells.

3. If you chose List From A Range, enter the range of cells elsewhere in your Google Sheet that contains the list of items you want to display as drop-down options. 4.

Let’s start from scratch. I’ll begin by creating a fresh dropdown list from a list of color options. If you’re not already sure how to add a drop-down list in Google Sheets, start with this ...