And in the Data Validation dialog box, click Settings tab, and choose List option from the Allow drop down list, and then click to select the list values that you want to use. Click Data > Data Validation > Data Validation, see screenshot:ģ. In this case, I select range A2:A6 to put the drop-down list, see screenshot:Ģ. Create a list of data and select a range that you want to put the drop down list values into. Method B Color coded drop down list with a handy tool-Colored Drop-down Listįor finishing this task, we need to create a drop down list first, please do as following steps:ġ. Method A Color coded drop down list with Conditional Formatting Are there any good suggestions to solve this? For instance, I have created a drop-down list of the fruit names, when I select Apple, I need the cell is colored with red automatically, and when I choose Orange, the cell can be colored with orange as following screenshot shown. In Excel, create a drop-down list can help you a lot, and sometimes, you need to color coded the drop down list values depending on the corresponding selected.
#How to add drop down list in excel how to#
Video of How to Add a Drop Down List in Excel from Lesson “ 17.6- Cell Validation” within the Complete Excel Training Titled “ Mastering Excel Made Easy v.2013-2010.How to add color to drop down list in Excel? You can then hide the column that contains the list of values for the drop-down menu if you do not want the users to see the list within the worksheet.Click the “OK” button to apply the drop downs to the selected cells.At the right side of the “Data Validation” dialog box, check the “In-cell dropdown” to set the cell’s data entry method to be a drop-down list from which the user can select a displayed choice and check the “Ignore blank” checkbox to ignore blank values within the list of drop-down values.Click the “Expand Dialog” button at the right end of the “Data Validation” dialog box to expand the dialog box again.The list you select must be on the same worksheet as the cell to which you are applying the cell validation. Click and drag over the cells you want to use as the list of values from which the user can select.Click the “Collapse Dialog” button at the right end of the “Source:” text box to collapse the “Data Validation” dialog box to a single line.Select the “List” choice from the “Allow:” drop-down on the “Settings” tab to restrict data entry in the selected cells to a list of cell values shown in the worksheet.In the “Data Validation” dialog box that opens there are three tabs: “Settings,” “Input Message,” and “Error Alert.” Click the “Settings” tab to set the range of allowable values for the selected cell or cells. Click the “Data Validation” button shown in the “Data Tools” button group on the “Data” tab in the Ribbon.Select the cells within which you want to create the drop down lists.The list of values MUST be on the same worksheet as the drop down lists. Type the list of values you want to use as the values within the drop-down list into the same worksheet within which you want to place the drop-down lists.Instructions on How to Add a Drop Down List in Excel Then select the cells where you want to show the drop downs lists and use the “Data Validation” tool to provide the user with a drop down list in those cells from which they can select a choice from the initial list of values you entered. To learn how to add a drop down list to Excel, first type the list of values you want the drop down list to display into a column within the Excel worksheet. You accomplish this in Excel by using the “Data Validation” feature. In this lesson, you will learn how to add a drop down list in Excel within a worksheet. Overview of How to Add a Drop Down List in Excel
0 kommentar(er)
