#Create a selection list in excel how to#
#Create a selection list in excel manual#
#Create a selection list in excel download#

To simplify this task, the teacher wants to create a drop-down menu to select each student’s appropriate result. They must easily determine which students have passed, just passed, or failed. Specify the source by selecting the list items (drop-down menu) in the worksheet.Ĭonsider the below example, which demonstrates the steps in detail:Ī teacher has a table of students’ Maths test marks and passing marks.Choose List from the drop-down of the “Allow” section.Under the Data Tools group, click on the Data Validation (icon).Select the cell for which you want to create a drop-down list.To create a drop-down list using list items, follow these steps:

#Create a selection list in excel download#

You can download this Drop Down List Excel Template here – Drop Down List Excel Template 1. Adding new values to the dropdown list is possible by adding them to the list items, giving users greater flexibility and ensuring that the list is always up-to-date.Whenever we attempt an invalid entry, Excel displays an error alert message.The use of dropdown lists also helps to maintain the consistency and accuracy of data, which is especially important for tasks such as data analysis and reporting.

#Create a selection list in excel manual#

This reduces the likelihood of making typos or errors that can occur with manual entry, improving data accuracy.Dropdown lists in Excel involve a simple click on the drop-down arrow and offer an easy and efficient way to select the option we desire.For example, we can use a drop-down list in Excel to mark student attendance in a class, reducing the risk of manual entry errors. We can use it to keep employee attendance records, perform large accounting data entry, or in financial modeling. With a drop-down list, you can limit the options someone can select to ensure they choose the correct information. It’s like a menu where you can pick what you want to eat. If you’ve found this tutorial helpful, like us and subscribe to receive more videos from Eas圜lick Academy.Updated JWhat is Drop Down List in Excel?Ī drop-down list in Excel is a feature that allows you to choose an option from a list that appears when you click on a cell. When both options are in, click on OK and the job is done! The simple drop-down list has been created! Then we’ll click on the ‘Data’ tab, go to ‘Data Tools’ and find ‘Data Validation’.Īgain, we’ll select the ‘List’ option, but now we’ll just type into the box two words – ‘Yes’ and ‘No’ – separated with a comma. We’ll have a look the second question, where, in the part ‘Your answer’, there will be just ‘Yes’ or ‘No’.Īs you already know, the first step will be selecting the cell in which we want to create the drop-down list.

#Create a selection list in excel how to#

Well, let’s move on and see how to create a short drop-down menu made of only two options. How to Create a Short Drop-Down List in Excel If anyone tries to type in a different option, Excel will not allow it. Press ‘Enter’ – and you’ve defined the contents of your drop-down list!Ĭlick on OK and you’re done! The column with ‘Your answer’ now contains a drop-down list from which you can choose your favourite month.Īs soon as you create the list, you can pick only from the options you’ve defined. Here we’ll click through to the spreadsheet ‘Months’ and select all months we want to include in the list.

Click on the icon on the right of the ‘Source’ box. Now you need to tell Excel where to find the data for the drop-down list. Then click on the tab ‘Data’, go to ‘Data Tools’ and select the option ‘Data Validation’.įind ‘Settings’ in the pop-up window and select ‘List’ from the menu. Now we’ll click back on the spreadsheet ‘Questionnaire’ and create our first drop-down list.Ĭlick into the cell in which you want to create the drop-down menu. I myself added a new spreadsheet, named it ‘Months’, and made a list of months that’ll be used for our drop-down menu.

So, if you want to make a drop-down menu with more options, it might be a good idea to create the list somewhere else, for example in a different spreadsheet. The answer to the first question will be a specific month of the year. How to Create a Longer Drop-Down List in Excel Those will be possible answers to our second question.īut let’s start from the beginning now. I’ll show you a way how to create a short drop-down list with only two items – ‘Yes’ and ‘No’. Then we’ll try something a little bit different. They’ll become our options for the answer to the first question. What we can use for drop-down items here are the months of the year. We’ll use this short questionnaire to see how simple it is to create a drop-down menu and you’ll be able to use these steps to create a list with any data you need.įirst, we’ll have a look at how to create a longer drop-down list with more options. 2 How to Create a Short Drop-Down List in Excel