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