Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
LEARN TO CREATE A SIMPLE DROP DOWN LIST IN EXCEL EASILY
G
Gyankosh-your daily dose of knowledge! Admin
2 Views • Jun 18, 2020
Description
DROP DOWN LIST IN EXCEL
If we have to work on the manual entries after the data has been filled , it can cause so much trouble for us if the data is not in the perfect format. If we keep the field just open for the entry, if there are a number of people fillling up that data , there are bright chances of format problems.
Now imagine if we have a 1000 rows and there are slight differences in the format of the entry, no matter it was done by different people, we ‘ll never be able to work on that and we might end up in correcting all the data wasting our time and resources.
SO, FOR SUCH CASES WE ALWAYS PREFER CREATING A LIST FOR A FIRM FORMAT AND CONTROLLING THE ENTRY OF THE DATA.
Complementary Article: https://gyankosh.net/exceltricks/crea...
Visit us at gyankosh.net
Join us at www.facebook.com/groups/gyankosh.net
Like us at www.facebook.com/gyankosh.net
If we have to work on the manual entries after the data has been filled , it can cause so much trouble for us if the data is not in the perfect format. If we keep the field just open for the entry, if there are a number of people fillling up that data , there are bright chances of format problems.
Now imagine if we have a 1000 rows and there are slight differences in the format of the entry, no matter it was done by different people, we ‘ll never be able to work on that and we might end up in correcting all the data wasting our time and resources.
SO, FOR SUCH CASES WE ALWAYS PREFER CREATING A LIST FOR A FIRM FORMAT AND CONTROLLING THE ENTRY OF THE DATA.
Complementary Article: https://gyankosh.net/exceltricks/crea...
Visit us at gyankosh.net
Join us at www.facebook.com/groups/gyankosh.net
Like us at www.facebook.com/gyankosh.net
More from User
02:11
LEARN TO CREATE A SIMPLE DROP DOWN LIST IN EXCEL EASILY
Gyankosh-your daily dose of knowledge! Admin
Related Videos
01:16
How to Create a Drop Down List in Excel: Easy Step-by-Step Tutorial [Learn How to Add Drop Down Lists in Excel 2025 Guide]
Mr. EXCEL HACKS
01:00
How do I create a dependent drop-down list in Excel - Excel Tips and Tricks
ExcelTips247
06:21
Excel Data Validation - How to create drop down list in excel and priorities a category
M. Javed VA
05:37
Excel Data Validation - How to create a drop down list in google sheets and priorities a category
M. Javed VA
03:16
How to create a 'radio button' Excel drop-down list
Strategize Financial Modelling
12:07
Create a searchable drop down list in Excel
School