How to Create a Drop-Down List in Excel
Aug 13, 2023
How to Create a Drop-Down List in Excel
Learn how to create a drop-down list in Excel - quick and easy. https://bit.ly/3CEAtVn https://www.youtube.com/c/ExcelTutori …https://www.easyclickacademy.com/how- …https://www.easyclickacademy.com/buy- …https://www.paypal.com/cgi-bin/webscr …https://www.linkedin.com/company/easy …https://www.facebook.com/EasyClickAca …https://techsmith.pxf.io/c/1266206/34 …
Content
0.06 -> Welcome to EasyClick Academy!
2.48 -> My name’s Mária and in this short tutorial, I’ll show you how to easily create a drop-down list in Excel.
8.82 -> Well, let’s have a look!
15.02 -> We’ll use this short questionnaire to see how simple it is to create a drop-down menu
19.24 -> and you’ll be able to use these steps to create a list with any data you need.
23.8 -> First, we’ll have a look at how to create a longer drop-down list with more options.
28.4 -> What we can use for drop-down items here are the months of the year.
31.98 -> They’ll become our options for the answer to the first question.
35.62 -> Then we’ll try something a little bit different.
38.72 -> I’ll show you a way how to create a short drop-down list with only two items – ‘Yes’ and ‘No’.
44.46 -> Those will be possible answers to our second question.
47.78 -> But let’s start from the beginning now.
50.6 -> The answer to the first question will be a specific month of the year.
54.24 -> So, if you want to make a drop-down menu with more options,
57.42 -> it might be a good idea to create the list somewhere else,
60.58 -> for example in a different spreadsheet.
63.1 -> I myself added a new spreadsheet, named it ‘Months’, and made a list of months
67.78 -> that’ll be used for our drop-down menu.
70.42 -> Now we’ll click back on the spreadsheet ‘Questionnaire’ and create our first drop-down list.
76.6 -> Click into the cell in which you want to create the drop-down menu.
79.9 -> Then click on the tab ‘Data’, go to ‘Data Tools’ and select the option ‘Data Validation’.
86.7 -> Find ‘Settings’ in the pop-up window and select ‘List’ from the menu.
92.18 -> Now you need to tell Excel where to find the data for the drop-down list.
96.74 -> Click on the icon on the right of the ‘Source’ box.
100.02 -> Here we’ll click through to the spreadsheet ‘Months’ and select all months we want to include in the list.
107.44 -> Press ‘Enter’ – and you’ve defined the contents of your drop-down list!
112.14 -> Click on OK and you’re done!
114.6 -> The column with ‘Your answer’ now contains a drop-down list from which you can choose your favorite month.
120.52 -> As soon as you create the list, you can pick only from the options you’ve defined.
125.02 -> If anyone tries to type in a different option, Excel will not allow it.
129.92 -> Well, let’s move on and see how to create a short drop-down menu made of only two options.
135.98 -> We’ll have a look the second question, where, in the part ‘Your answer’, there will be just ‘Yes’ or ‘No’.
142.84 -> As you already know, the first step will be selecting the cell in which we want to create the drop-down list.
148.84 -> Then we’ll click on the ‘Data’ tab, go to ‘Data Tools’ and find ‘Data Validation’.
155.9 -> Again, we’ll select the ‘List’ option, but now we’ll just type into the box two words
161.32 -> Yes’ and ‘No’ – separated with a comma.
166.66 -> When both options are in, click on OK and the job is done!
170.94 -> The simple drop-down list has been created!
173.98 -> If you want to know how to edit the drop-down menu, change the options, or remove the list completely,
179.08 -> watch our next video tutorial.
181.26 -> If you’ve found this video helpful, like us and subscribe to receive more videos from EasyClick Academy.
187.68 -> Learn more from tutorials that help you use Excel quick and easy!
192.36 -> Thanks for watching! See you soon in the next video!
Source: https://www.youtube.com/watch?v=mMOe32zFaHU
