# How to add a drop-down list in Google Sheets

If you prefer not to manually enter the **attributes** of a value **into the corresponding cell** in Google Sheets each time, you can utilize drop-down lists. These lists allow you to select from predefined attributes. Below, we explain how to create drop-down lists in Google Sheets.

## Why are drop-down lists so useful in Google Sheets?

If a cell contains a drop-down list in Google Sheets, users can select a value from a pre-defined list with just one click. The selected value is then displayed in the cell. Selecting an existing value is much easier than having to type the value manually. Drop-down lists also help keep your data accurate and consistent. If multiple people are working on the same spreadsheet, using drop-down lists means that only accepted values are possible. This results in **fewer typos** and **greater time savings** which are among the many good reasons for using drop-down lists in Google Sheets.

Tip Discover the key differences between Google Sheets and Microsoft Excel in our comprehensive comparison article: [Google Sheets vs. Excel](https://www.ionos.ca/digitalguide/online-marketing/online-sales/google-sheets-vs-excel/).

## How to create drop-down lists in Google Sheets step by step

Google has made it as easy as possible for users to add drop-down lists to individual cells. To add a drop-down list, follow the steps below:

**Step 1**: Choose a cell, then right-click and select **Dropdown**:

[![Image: Google Sheets: “Dropdown” option in the menu](https://www.ionos.ca/digitalguide/fileadmin/_processed_/9/6/csm_google-sheets-drop-down-menu_f041879110.webp "Google Sheets: “Dropdown” option in the menu")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2024/google-sheets-drop-down-menu.png) Select the cell in your Google spreadsheet where you want to insert the drop-down list. **Step 2**: Enter all the desired **elements of the drop-down list** manually under **Criteria**. In addition to choosing a unique name, you can also assign an individual color to each element. To confirm the values, click on **Done**:

[![Image: Google Sheets: Example of drop-down elements](https://www.ionos.ca/digitalguide/fileadmin/_processed_/2/e/csm_google-sheets-drop-down-elements_cde17ffad5.webp "Google Sheets: Example of drop-down elements")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2024/google-sheets-drop-down-elements.png) Creating the elements in the Google spreadsheet menu “Data validation rules”. **Step 3**: A drop-down list has been added to the cell you selected. You can confirm this by checking for the **downward arrow** in the cell:

[![Image: Google Sheets: Drop-down list](https://www.ionos.ca/digitalguide/fileadmin/_processed_/e/7/csm_drop-down-list-sheets_ab2ae845e5.webp "Google Sheets: Drop-down list")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2024/drop-down-list-sheets.png) Cell with drop-down list created in Google Sheets. **Step 4**: **Click on the arrow** to open the drop-down list in the cell. Check whether the elements are listed in the desired order and are spelled correctly. If you want to make changes, click on the **Edit button** option.

[![Image: Elements of the Google Sheets drop-down list](https://www.ionos.ca/digitalguide/fileadmin/_processed_/a/c/csm_drop-down-google-sheets-example_f8ce4e93fb.webp "Elements of the Google Sheets drop-down list")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2024/drop-down-google-sheets-example.png) The elements of your created Google Sheets drop-down list are automatically arranged as specified in the data validation menu. **Step 5**: Do you want to add a warning to your Google Sheets drop-down list to alert users when an invalid value has been entered? Go to the data validation menu, click on **Advanced options** and select the **Show a warning** option.

[![Image: Google Sheets: Activate a warning for drop-down lists](https://www.ionos.ca/digitalguide/fileadmin/_processed_/6/6/csm_google-sheets-invalid-data-menu_196e9599c8.webp "Google Sheets: Activate a warning for drop-down lists")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2024/google-sheets-invalid-data-menu.png) Google Sheets will reject any incorrect value entered. The result of an incorrect entry is as follows:

[![Image: Google Sheets: A warning is displayed for an invalid entry](https://www.ionos.ca/digitalguide/fileadmin/_processed_/b/8/csm_google-sheets-drop-down-invalid-value_e79b1274cd.webp "Google Sheets: A warning is displayed for an invalid entry")](https://www.ionos.ca/digitalguide/fileadmin/DigitalGuide/Screenshots_2024/google-sheets-drop-down-invalid-value.png) The warning for improper use of the Google Sheets drop-down list is clearly displayed.  Tip In the Digital Guide, you can find out [how to edit Google Sheets drop-downs](https://www.ionos.ca/digitalguide/online-marketing/online-sales/edit-drop-down-lists-in-google-sheets/) as well as more information on formatting cells in the article “[Google Sheets: Conditional formatting explained simply](https://www.ionos.ca/digitalguide/online-marketing/online-sales/google-sheets-conditional-formatting/)”.


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