Creating Drop-Down Lists in Excel to Prevent Data Entry Errors
Expert Excel With Dr. Chang - Episode 2
Creating Drop-Down Lists in Excel to Prevent Data Entry Errors
In this Episode of Expert Excel with Dr. Chang, we are exploring how to prevent data entry errors by creating Drop-Down Lists.
Important Times:
00:00:12 - Why Drop-Down List?
00:00:38 - How to Create Drop-Down List
00:01:06 - How to Create Drop-Down List from Preexisting Cells
How to Create Drop Down Lists
Click on Data Menu
Click on Data Validation icon
Change the Allow from Any Value to Lists
Fillup the values either by inputing the value seperated by comma, or defining the cells containing the list
Resource File:
https://bit.ly/2Vh17BW
If there are any requests for Excel Tips and Tricks, please write them down in the comment and I'll try to create a video answer in the future.
By Asst. Prof. Dr. Pisal Setthawong
Department of Digital Business Management
Assumption University
Facebook:
/ pisal.setthawong
Music Credits:
Cyberleaf Studio - TechShow Loop 1