How To Create a Dropdown in Google Sheets

how to create a dropdown in google sheets

This post was last Updated on by Himanshu Tyagi to reflect the accuracy and up-to-date information on the page.

In this tutorial, you will learn how to create a dropdown in Google Sheets. We share Google Sheets with students and colleagues from time to time, and we don’t want them to type in their answers. Sometimes you want to give people the option of clicking on a small drop-down menu to get different options instead of typing something into a cell so that you can keep track of their choices.

Google Sheets offers a straightforward solution for this. Stay tuned until the end of the article to learn how to do this in manageable steps.

Also ReadHow To Sort Spotify Playlists By Date Added, Release Date, etc.

Why Use Drop Down Lists in Google Sheets?

Using drop-down lists in Google Sheets has lasting advantages. You can save a significant amount of time and hassle by creating drop-down lists for multiple cells in Google sheets. With drop-down lists, you can ask the user to select from a list of predefined options.

This becomes handy when there is large-scale data entry work to do. You don’t need to enter the same data again and again. You can select it from the drop-down list. Another use case is when there is the same set of entries for each cell. In place of entering data, you can create a drop-down list for the user to select from the range of options for the specified cell. 

Also ReadHow to Create a Poll in Gmail Email for Free

Adding a Drop-down Menu List to Google Sheet

  • Select the cell where you want to add the drop-down list.
  • In the menu bar, go to Data> Data Validation.
  • From the drop-down menu, choose the criteria. Among many options, the two prominent ones are a List of items and a List from a range.Creating a drop down list in Google Sheets

Also ReadHow to Download All Images From a Subreddit

List from items: The “List of items” option is the simplest. Enter the values, separated by commas, in the order you want them to appear in your list.

List from a range: Because typing a long list of items is inconvenient and error-prone, this is the recommended criteria option if you have more than a handful of items.

  • You have the option of entering the range as a formula. Alternatively, you can click the grid in the input box to open a second popup to select the range with your mouse.
  • Make sure the “Show dropdown list in cell” checkbox is selected.
  • Other options, such as “showing warning” and “reject input,” can be used by simply checking the boxes that deal with invalid data entry.
  • Click Save after making the desired changes.

Also ReadHow To Listen To Twitch Audio-Only In The Background

Editing the Data in the Drop-down List in Google Sheets

  • Select the cell or cells with the data validation setting you wish to change.
  • Go to Data> Data Validation.
  • Edit the List Of Items in the text box to the right of the Criteria field in a web browser.
  • Edit the text as needed to add or remove items, and remember to separate each item with a comma.
  • When you’re finished making changes, click Save to apply them to your chosen cells.

Also ReadHow To Flip An Image in Chrome [Rotate An Image In Chrome]

Adjusting the Range in Google Sheets

  • Select the cell (or cells) containing the data validation setting you want to modify.
  • Navigate to Data > Data Validation in a web browser.
  • In the Range field, change the range to indicate the sheet and cells that contain the drop-down list options you want.Editing Drop down list range in Google Sheets
  • Tap Save to keep your adjusted range.

Also ReadHow to Change YouTube Double-Tap Skip Time

Deleting a Drop-down List in Google Sheets

  • Select the cell where you want to add the drop-down list.
  • Go to Data> Data Validation.
  • Click on the Remove Validation button.Remove drop down list from Google Sheets

Also ReadHow To Download Instagram Photos In Firefox Using Context Menu

Frequently Asked Questions(FAQs)

Is It Possible To Copy the Drop-down List to Another Cell?

The answer is YES, you can. You need to use copy and paste hotkeys[ctrl+C and ctrl+V] to copy the drop-down list to another cell. This method will let you copy the formatting as well.

What Should I Do if an Error #N/a Appears on a Cell?

First and foremost, do not be worried. A simple error message appears when no division is selected from the drop-down menus. Once we occupy the remaining division drop-downs, the errors will vanish.

Also ReadHow To Search YouTube Videos By Length

Can I Select Multiple Options in a Drop-down Google Sheets?

In dropdown lists, selecting multiple options is very useful. In general, Google Sheets does not support this functionality. Each user will be limited to one option.

Wrapping Up

So this is all about making a drop-down menu in Google Sheet. This feature is handy if you want to control the responses you expect. If you enjoyed the article, please spread the word.

Read our latest articles: