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.
