Intro are you aware that using Microsoft Excel you can
create a drop- down list that helps you insert your data without having to type it in manually
come let me show you how it's done here I already have my source data where I'll be bringing
in the information that I will be inserting inside my drop- down list so on the drop- down
list in the space provided for Department I'll highlight the column using the Office 365 version
I have the option to search I'll right click and on this box that has searched menu I'll type
in data and click on validation then in this section I'll click and select list in the source
option I'll go to my source data and highlight the entire department information press enter and
click okay so in that space you can see that all the department information is already inserted
in my drop down list so all I need to do is to click and select any Department that I want and
in the gender section I will also highlight right click type in data click on validation go back
and select list here I can as well type in my gender information I'll type male put a comma
type in female click okay so all I need to do is to click select and insert is as simple as
that using other version of excel that is not Office 365 like this particular version is
Microsoft Excel 2013 version working with the same information I would come over my drop-
down list and highlight the department column then when I right click you can see that I do not
have the option to search like the first one so what I would do is to go to data tab then I will
go to data validation click on data validation then I would change any value to list then to
my source option I'll go to my source data and select the entire staff department click enter
click okay but with this version you can see that the staff department was presented more
than once according to the manner it was shown from the original Source data which was not the
case when we used the Office 365 version so to address that what we will do is to go and remove
duplicate values from the staff department because I don't want to tamper with this original data
I would copy the staff department and paste it another column I would go to data tab click on
remove duplicate and I'll select continue with Remove duplicates current selection click on remove duplicate yes
we are working on column D and we click okay so we can see the number of duplicate values that
were removed and unique values remaining now back to our drop- down list we would go back
and select the column click on data and to data value validation we select data validation
we'll click on list to the source we'll go and select our unique values press enter click okay
now you can see that duplicate values have been removed and you can go and select any Department
that is applicable to each staff and back to the gender option click on data validation then
we select list the source can be typed in male comma female and click okay so here we have
our gender information in the drop- down list I will just copy the formula down across other
rows then we can select so this is how you create a drop- down list in Microsoft Excel
using different versions of Microsoft Excel thank you for watching please don't forget to
subscribe like and share this video bye for now