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?,
