27.0K
EXCreate 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?,
Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@RabiGurungXybernetics/shorts
https://www.tiktok.com/@xybernetics247
https://www.instagram.com/rabi.gurung247/
https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/
https://twitter.com/XyberneticsInc/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/
#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks
@exceltips247
