{"id":42388,"date":"2023-05-02T20:52:48","date_gmt":"2023-05-02T18:52:48","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=42388"},"modified":"2025-12-17T22:25:33","modified_gmt":"2025-12-17T21:25:33","slug":"how-to-create-dropdown-lists-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/google-sheets-features\/how-to-create-dropdown-lists-in-google-sheets\/","title":{"rendered":"C\u00f3mo crear listas desplegables en Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

The dropdown feature in Google Sheets is a helpful tool that can save you time and make your data more accurate. It’s easy to set up, and it helps prevent errors and typos. You can customize the lists to fit your needs, and they’re easy to use.<\/span><\/p>\n

Essentially, a dropdown list is a <\/span>data validation<\/span><\/a> tool in Google Sheets that allows you to create a list of options for a cell. When users click on the cell, they can simply select an option from the dropdown menu that will appear on the screen. By creating a dropdown list, users can limit the available options to predefined choices, making it easier to enter data accurately and consistently.<\/span><\/p>\n

In this article, we’ll take a closer look at some of the best practices and advanced features of dropdown menus in Google Sheets.<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”benefits” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

What are the benefits of using dropdown lists in Google Sheets?<\/span><\/h2>\n

There are many benefits of using dropdown lists. Some of these benefits include:<\/span><\/p>\n

Accuracy:<\/strong> Dropdown lists in Google Sheets can help improve data accuracy by limiting the available options to predetermined choices. This eliminates the chance of errors and typos, which makes it easier to analyze the data later.<\/span><\/p>\n

Time-Saving:<\/strong> Dropdown lists can save you a ton of time by providing a quick and easy way to enter data. Instead of typing in the values, all you need to do is select an option from the dropdown menu.<\/span><\/p>\n

Consistency<\/strong>: With dropdown lists, you can rest assured that your data will remain consistent because users will have access to a predefined set of options to choose from.<\/span><\/p>\n

If you want to learn how to build dropdown lists from scratch, you can also check out this article about <\/span>data validation in Google Sheets<\/span><\/a>. Here, we’ll take a look at some of the best practices and advanced features of dropdown menus.\u00a0<\/span><\/p>\n

In this example, let’s take a look at a spreadsheet that includes various car makes, models, and their corresponding prices.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-1.png” alt=”dropdown in google sheets 1″ title_text=”Dropdown 1″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”up-to-date” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to keep the list up-to-date<\/span><\/h2>\n

If you select the <\/span>Dropdown<\/b> criterion to create your menu, you need to input all the items manually. Whenever you need to update the dropdown list, you have to open the data validation sidebar and edit the list of items.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-2.png” alt=”dropdown in google sheets 2″ title_text=”Dropdown 2″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

However, if you select <\/span>Dropdown (from a range)<\/b>, you can update the list automatically whenever you add or remove items from that range.<\/span><\/p>\n

In this example, Google Sheets has created the dropdown list from the <\/span>Cars<\/b> tab, pulling data from the specified range (starting from column A2 and continuing downwards). If you add more data within that specified range, Google Sheets will automatically update the dropdown list.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-3.png” alt=”dropdown in google sheets 3″ title_text=”Dropdown 3″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”assign-colors” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to assign colors to items<\/span><\/h2>\n

If you think your dropdown menu looks bland and unattractive, you have the option to customize it by assigning different colors to each item.<\/span><\/p>\n

Click the circle next to the item you want to customize. Now, all you have to do is choose a color for this item’s background.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-4.png” alt=”dropdown in google sheets 4″ title_text=”Dropdown 4″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

You can assign a different color to each item. Not only will this make your spreadsheet more visually appealing, but it will also facilitate data analysis and visualization.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-5.png” alt=”dropdown in google sheets 5″ title_text=”Dropdown 5″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”advanced-options” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

The importance of the advanced options<\/span><\/h2>\n

When build a dropdown menu and apply data validation in Google Sheets, there are a few advanced options you can use to customize the validation criteria.<\/span><\/p>\n

If you want to show some help text for a selected cell, check the box and write your custom message.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-6.png” alt=”dropdown in google sheets 6″ title_text=”Dropdown 6″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

When you input invalid data instead of choosing an item from the dropdown menu, Google Sheets will show you a warning message.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-7.png” alt=”dropdown in google sheets 7″ title_text=”Dropdown 7″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

However, you can also choose the option <\/span>Reject the input<\/b> if the data is invalid. Google Sheets will automatically reject the input and show a message box.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-8.png” alt=”dropdown in google sheets 8″ title_text=”Dropdown 8″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

You can also customize the display style if you don’t want the dropdown chips. When you select <\/span>Arrow<\/b>, Google Sheets will only display a down arrow in the cell.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-9.png” alt=”dropdown in google sheets 9″ title_text=”Dropdown 9″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

If you choose <\/span>Plain text<\/b>, the dropdown menu won’t be visible. When you double-click the cell, the menu will appear. If you start typing the text in the cell, Google Sheets will show you the available options that match your text.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-10.png” alt=”dropdown in google sheets 10″ title_text=”Dropdown 10″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”dependent-dropdown” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to create dependent dropdown lists<\/span><\/h2>\n

Dependent dropdown lists allow users to select options from a dropdown menu based on the selection made in a previous dropdown menu.<\/span><\/p>\n

In other words, the choices presented in the second dropdown menu depend on what was selected in the first dropdown menu. For example, if you select Toyota, the options available in the second dropdown menu will be Toyota vehicles.<\/span><\/p>\n

In order to build a dependent dropdown list, check out the instructions below.<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

1. Create the first dropdown menu<\/span><\/h3>\n

First, select <\/span>Dropdown (from a range)<\/b> in the <\/span>Criteria<\/b> section.<\/span><\/p>\n

Select the cell where you will apply the data validation. In this example, I’ll create the dropdown menu in cell F2.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-11.png” alt=”dropdown in google sheets 11″ title_text=”Dropdown 11″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

After selecting the range where you want to create the dropdown, choose the range of cells containing all the options you need to add to the list (column A, from cell A2 onwards).<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2. Filter data from the first dropdown<\/span><\/h3>\n

I’ll use the <\/span>FILTER<\/b> function to create a formula that returns only the available options that match the first column.<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.20.2″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

FILTER(range, condition1, [condition2, …])<\/span><\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

The range is the data to be filtered. In this example, it’s the data from column B.\u00a0<\/span><\/p>\n

The condition is the column or row containing values corresponding to the first column. It’s the data from the first column that matches the value in cell F2.<\/span><\/p>\n

Here’s the formula: =filter(B2:B,A2:A=F2)<\/strong><\/span><\/p>\n

When I select a car make from the menu in cell F2, all the available car models from that brand will appear in column D.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-12.png” alt=”dropdown in google sheets 12″ title_text=”Dropdown 12″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3. Create the second dropdown<\/span><\/h3>\n

I’ll create another dropdown menu in cell G2, pulling data from column D.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-13.png” alt=”dropdown in google sheets 13″ title_text=”Dropdown 13″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

When I choose a car make in the first menu, the second dropdown will change based on the option selected in the first dropdown list.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-14.png” alt=”dropdown in google sheets 14″ title_text=”Dropdown 14″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Now, I can create a formula using the FILTER function again to display the price.<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/Dropdown-15.png” alt=”dropdown in google sheets 15″ title_text=”Dropdown 15″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”data-validation” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Take your data validation to the next level<\/span><\/h2>\n

That’s how you can create a dependent dropdown menu in Google Sheets.\u00a0<\/span><\/p>\n

If you want to take data validation to the next level, you should give <\/span>Sheetgo forms<\/span><\/a> a try. With Sheetgo forms, you can apply data validation and create dependent dropdowns very easily with just a few clicks.<\/span><\/p>\n

What’s more, you can make it even easier to input data in Google Sheets. You can input data in Google Sheets easily by simply filling out a form. You can share the form with your colleagues without granting them access to your spreadsheet.<\/span><\/p>\n

Click the button below to start using Sheetgo Forms.<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

The dropdown feature in Google Sheets is a helpful tool that can save you time and make your data more accurate. It’s easy to set up, and it helps prevent errors and typos. You can customize the lists to fit your needs, and they’re easy to use. Essentially, a dropdown list is a data validation […]<\/p>\n","protected":false},"author":42,"featured_media":42182,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-42388","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/42388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=42388"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/42388\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=42388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=42388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=42388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}