How to make a drop-down menu on Google Sheets (Easy steps)

Black Friday is around the corner! Get an up to 65% off on yearly plans. ⏰

Google Sheets is an excellent tool for businesses to save data. Especially for businesses that collect large ranges of data, most of them use Google Sheets to save that data to use later. So, the practical usage of Google Sheets matters. The more you know its hacks, the more you will use the tool like a professional.

In our article, you will learn an excellent feature of Google Sheets that makes it easy to categorize data: the Google Sheets drop-down list. We will show you step-by-step instructions on how to add a drop-down list in Google Sheets. To learn how to do it correctly and get more information about the topic, keep reading!

You can save lots of data on Google Sheets. It might be problematic to categorize all lists of items. At this point, the Google Sheets dropdown menu can be super-helpful. You can add a dropdown list in your Google Sheets because it categorizes the range of cells and saves time. Thanks to it, you don’t need to look for specific data; your sheet will be more organized.

In this section of our article, you will find the answer to “How do I create a dropdown in Google Sheets?”. Following some basic steps, you can easily create a dropdown menu. Check out the steps given below:

1. Open Google Sheets

Google Sheets dashboard

You need to sign in to your existing Google account. If you do not have one, you can create one and continue. Then, open Google Sheets to view the specific sheet you want to add a drop-down menu.

2. Select Cell

Select the cell for the drop-down menu

You need to decide which cell to add to a dropdown menu. After deciding which data to categorize, you can click on the data you need.

3. Click “Dropdown”

Right-click and choose Dropdown

When you decide on the cell, you need to click right. After clicking right, you will see “Dropdown” from the menu.

4. Add data validation rules

Add items to your dropdown menu

When you click on Dropdown, you will see the “Data validation rules” window on the right side of the page. Based on your needs, you can add or remove items. Also, you can change the criteria from the menu. It is possible to choose many other options, including a text box, checkbox, date, etc.

💡 You can choose the cell range to apply the dropdown list or extend the circle in the lower right of the cell as much as you want.

5. Customize the details

After clicking Done, you can change the display style, such as the colors of the criteria. Moreover, you have advanced options to show or reject invalid or display data. Also, do not forget you can change the dropdown’s text from the toolbar.

Edit your dropdown menu

Frequently asked questions about drop-down menus

You have learned how to add a drop-down menu on Google Sheets, but you might still have questions about the topic. If you need further information about the topic, here are some frequently asked questions (FAQs) about drop-down menus:

How do I create a check box in Google Sheets?

The process of creating a checkbox in Google Sheets is really simple. All you need to do is follow these steps:

Click right and choose Dropdown.
From Data validation rules, click criteria and choose Checkbox.
When you click Done, the checkboxes will be created.

Are drop-down menus effective?

Drop-down menus are effective in organizing and categorizing wide data entries in your Google Sheets. With a drop-down menu, you can put similar data in the same categories and make it find and understand better.

How do I create a drop-down menu in Excel?

The steps you need to follow to create a dropdown menu in Excel are different from Google Sheets. Similarly, you can create it in a few steps. Here are the steps:

Select the data from the list.
From the ribbon, choose “Data Validation” from the “Data” section.
Choose “List” from “Allow”.
Click “Source” and type the text you want to.

Final words

To wrap it all up, Google Sheets is a perfect tool to save the data you collect. Effective usage of the tool will boost your success. To achieve this, you can use Google Sheets formulas or apply some tips on the Google Sheets, and drop-down menus are only one of them.

In our article, we gathered all the detailed data about how to make a drop-down menu on Google Sheets and more. Now that you have learned everything about them, you can take action and strengthen your power on Google Sheets!

Şeyma Beyazçiçek

Şeyma is a Content Marketing Strategist at forms.app specializing in surveys, giveaways, statistics, memes, and online forms. She enjoys art, reading, and creative writing.