Create a drop-down list using a list of items.To create a drop-down list that allows multiple selections, you need to do two things: Allowing Multiple Selections in a Dropdown list (with repetition)įor this tutorial, I will use the following dataset of items and will create the drop-down in cell C1 Let’s begin by creating a fresh dropdown list from a list of color options.Ĭlick here to get a copy of the Google Sheets that has multiple selections enabled (make a copy to use it). Multiple Selection in Drop Down (Whole Column or Multiple Cells).Allowing Multiple Selections in a Dropdown list (without repetition).Adding the Google Apps Script to Enable Multiple Selections.Allowing Multiple Selections in a Dropdown list (with repetition).In this article, I will show you how to create a drop-down list that allows multiple selections (something as shown below). It is possible to make your dropdown list allow multiple selections by using Google AppScript. The good news is that there’s a way around this. You are only allowed one option at a time. Unfortunately, this option is not traditionally allowed in Google Sheets. Therefore, multiple selections in dropdown lists can be quite useful. In such cases, it’s possible that the user knows more than one and there is a need to select multiple options from the drop-down.

Or might want to get a list of coding languages the user is proficient in. For example, when there’s a collection of colors for you to choose from, you might like more than one color. Often times you may need to select more than one option in a drop-down list. However, you will notice that the default Google Sheets dropdown list allows the user to only select a single item from the list. With just a few clicks, you can create either a single-cell dropdown or populate a whole row or column with dropdown lists. Google sheets let us use this functionality with ease. It gives users a clear look at all the available options and also makes sure the user selects only the items allowed.Ī drop-down list also ensures that there are fewer errors as the user can now choose from a pre-defined list instead of manually typing the cell content. The main purpose of drop-down lists in Google Sheets is to offer options that a user can choose from.

Dropbox in google sheets