Create a dropdown list in Google Sheets - Excel Tips and Tricks

Learn how to create a drop down list in Google sheet. I will cover the answer to how do I make multiple selections in a drop-down list in Google Sheets and how do I create a dependent drop-down list in Google Sheets for multiple rows will be covered in the next video.

These other steps covered in the video.

METHOD 1 - Add Dropdown Menu
1) Select Subject column
2) Data ~ Data Validation
3) Add Rule
4) Criteria to "Dropdown"
5) Add "Maths", "Science" and "English"
6) Assign colors for each selection.
7) Done

METHOD 2 - Add Dropdown Menu
1) Select any cells
2) Type @ and select "Dropdowns"
3) Enter items and change color
4) Done


How do I create a drop-down list in Google Sheets?,How do I create a cascading drop-down list in Google Sheets?,How do I make multiple selections in a drop-down list in Google Sheets?,How do I create a dependent drop-down list in Google Sheets for multiple rows?,