# How to edit drop-down lists in Google Sheets

In Google Sheets, it’s possible to create drop-down lists within a cell. If you want to add new choices, you can easily edit or extend your Google Sheets drop-down list.

## What is a Google Sheets drop-down list?

A drop-down list is a list that allows users to select one of several predefined values. In the Google Sheets spreadsheet program, you can create drop-down lists in cells similar to the way you would create [drop-down lists in Excel](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/creating-an-excel-drop-down-list/). In addition to creating drop-down lists, you may also need to edit them from time to time, for example, if the options **are no longer up to date** or need to be renamed.

## How to edit a Google Sheets drop-down list

If you want to edit drop-down lists in Google Sheets, you have several options.

Tip Google offers a comprehensive range of different apps for companies. With the [Google Workspace](https://www.ionos.co.uk/office-solutions/google-workspace "Google Workspace IONOS") solution from IONOS, you can use these tools and a Gmail account together with a domain from IONOS. Benefit from real-time collaboration and online storage for your data.

### Edit with the editing tool

You can use the **built-in editing tool** to expand or edit your Google Sheets drop-down list. Simply follow the instructions below:

1. Click on the cell with the drop-down list that you want to edit.
2. You’ll see a **pencil symbol** in the bottom right-hand corner. Click on this.
3. You can now edit your Google Sheets drop-down list. Continue just as you would when [creating a Google Sheets drop-down list](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/drop-down-lists-in-google-sheets/).

[![Image: Edit Google Sheets drop-down list with editing tool](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/1/6/csm_google-sheets-drop-down-list-pencil_3d96979ef5.webp "Edit Google Sheets drop-down list with editing tool")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2024/google-sheets-drop-down-list-pencil.png) To edit a drop-down list in your Google spreadsheet, you can simply click on the pencil icon. ### Edit by right-clicking

Another simple and intuitive way to expand or edit a Google Sheets drop-down list is by **right-clicking** on the cell.

1. Right-click on the cell containing the drop down list.
2. A list with various options will open. Select the **Dropdown** option.
3. You can now edit your Google Sheets drop-down list in the drop-down editor.

[![Image: Edit Google Sheets drop down list with right-click](https://www.ionos.co.uk/digitalguide/fileadmin/_processed_/8/d/csm_google-sheets-drop-down-right-click_ca1335e4d8.webp "Edit Google Sheets drop down list with right-click")](https://www.ionos.co.uk/digitalguide/fileadmin/DigitalGuide/Screenshots_2024/google-sheets-drop-down-right-click.png) To edit a drop down list in your Google spreadsheet, you can right-click on the relevant cell and select the dropdown editor.


This is a markdown version of: [https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/edit-drop-down-lists-in-google-sheets/](https://www.ionos.co.uk/digitalguide/online-marketing/online-sales/edit-drop-down-lists-in-google-sheets/) for AI/LLM consumption.