![how to make a drop down list in excel 2010 how to make a drop down list in excel 2010](https://i.ytimg.com/vi/-qgEmhuXfpw/maxresdefault.jpg)
HOW TO MAKE A DROP DOWN LIST IN EXCEL 2010 HOW TO
So that the favorite color of those students can be selected.In this article, we will learn how to create dynamic drop down list in Microsoft Excel.Īs we know Data Validation feature improves the efficiency of data entry in excel and reduces mistakes and typing errors. The following instructions detail how to create a drop down list in Excel 2010. Sheet2 select the list and click on the icon again. Form Validation criteria choose the List option. Go to the Data tab on the Ribbon then click Data Validation. Sheet1 and select the fields you need to be a drop down list field. This tutorial will show you how to use the data validation tool to create a drop-down list of options in Microsoft Excel. Select the cell where you want the list to go and then click the Data tab and go to the Data Tools group. Right click on the drop-down icon and choose Format Control In the Input range enter the range of cells that contains the list. Select the cell that will contain the drop-down list cell B2 in this example. First of all we need to put some data into.Įxcel 2010 How to create drop down lists. You can click Kutools Drop-down List Searchable Drop-down List Settings to open this Searchable Drop-down List dialog box. Select the Data option Choose Data Validation from the drop-down menu to display the Data Validation dialogue box. Data Validation Dialogue box appears as follows. To create Drop Down list in Excel follow the below steps as shown below. Click on the Data Tab.Įnter the list of items in a range. So for the dummy data in Column A there is a list of student and in the B I. Select the cell where you want the drop-down to appear.įor example I have kept a few students names and I want to show a drop down that will have the color names. This shows you how to create a customized drop-down list in excel 2010. This will allow you to display the information of 1 employee at a time instead of hav.
![how to make a drop down list in excel 2010 how to make a drop down list in excel 2010](https://cdn.ablebits.com/_img-blog/dynamic-dropdown/create-main-dropdown.png)
![how to make a drop down list in excel 2010 how to make a drop down list in excel 2010](https://www.excelcampus.com/wp-content/uploads/2014/11/DependentDropdownListsExampleinExcel.png)
Sheet2 and enter in your drop down list options. Advanced excel drop down list.ĭrag and drop Combo Box from under the Developer toolbar. To create a drop-down menu do the following. On the Data tab in the Data Tools group click Data Validation. Now the searchable drop down list are created.Ĭreating a drop-down list. Make cell B3 the active cell by selecting it from the list. When clicking a drop down list cell a list box will pop up with all drop-down items listing inside type in a character the corresponding items will be searched out at once you can click the needed item to insert into the cell. Excel 2010 How to create drop down lists. In 2011 it is located in the same place but within Validate. This tutorial uses Microsoft Excel.Ĭreate A Drop Down List Using Static Values. Steps to Create a Drop-down List in Excel 2010. Select the source tab where excel will ask for the database cell to appear in the drop-down list. On the Settings tab in the Allow box click List. In the Data Validation dialog box on the Settings tab. In Excel 2010 Data Validation will be its own option. Select the Settings to tab from the drop-down menu. If you already made a table with the drop-down entries click in the Source box and then click and drag the cells that contain those entries. To create your own drop-down list for some cell do the following. How to make drop down list in excel 2010. How To Create A Drop Down List In Excel 2010 Excel Drop Down List Hacking Computer A how to video on creating drop down menus in Excel. If you want a drop down list of static values that dont change and arent dependent on the contents of other cells you can type in the values directly. Go ahead and pick a cell for your drop-down list Im going to name C1 Todays Cup and then use C2 for my drop-down list and click Data Validation which will be located under the Data tab.