Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
If the player does not load, watch on Dailymotion directly.
Why is Drop Down List in Google Sheet better than in Excel - Excel Tips and Tricks
1 Views • Aug 18, 2025
Description
Adding Drop Down List
1) Select cell B2
2) Data ~ Data Validation
3) Add Rule
4) Criteria to "Dropdown (from a range)"
5) '212'!A14:A
6) OK
7) Done
8) Close Data Validation Rules window
Why is Drop Down List in Google Sheet better than in Excel,What makes Google Sheets better than Excel?,What are two differences between Google Sheets and Excel?
More from User
Add Time Hours Minutes Seconds In Excel - Excel Tips and Tricks
ExcelTips247
Add Minute To Time In Excel - Excel Tips and Tricks
ExcelTips247
Employee Time Tracker in Excel - Excel Tips and Tricks
ExcelTips247
3D Donut Chart in Excel - Excel Tips and Tricks
ExcelTips247
Simple Dependent Drop-Down List in Excel - Excel Tips and Tricks
ExcelTips247
TOROW Excel Function Not Working - Excel Tips and Tricks
ExcelTips247
Related Videos
Dependent Drop Down Lists In Google Sheet - Excel Tips and Tricks
ExcelTips247
Create a dropdown list in Google Sheets - Excel Tips and Tricks
ExcelTips247
Quick and Easy Way to Add Multiple rows and column in Excel and Google Sheets - Excel Tips and Tricks
ExcelTips247
Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet
Kindletest
Excel Tips and Tricks - Online Attendance Sheet With Checkbox In Google Sheet
ExcelTips247
UPDATED! Auto Expand Drop Down List Using Dynamic Array In Excel - Excel Tips and Tricks
ExcelTips247