How to Apply Dropdown for Multiple Selection in Google Sheets

Introduction

Google Sheets is a powerful spreadsheet tool that offers many features to organize and analyze data. One of the most commonly used features is the dropdown list, which allows you to select predefined options in a cell.
But by default, Google Sheets only allows one selection at a time in its dropdown menu.
What if you want to select multiple items from a dropdown?
This guide will walk you through two methods to create a dropdown for multiple selections in Google Sheets.

Let’s Go

First Of all Open Your Google sheet

We Have This Data For Dropdown In Google Sheet>

We Have Put Here Dropdown For Multiple Selection>

Step 1

Select The Ranges

Go To Data And Then Data Validation >

Click on Data Validation And then Click New Rule>

Click on Add Rule

Click On Apply To Range

Select Your Range And The Ok

And Scroll Down The Right Side And Click On Allow Multiple Selection

And Then Ok

See The Magic >

Final Interface

Thank You

Leave a Reply

Your email address will not be published. Required fields are marked *