Copy the empty box to other cells to include the drop-down menu there. Now, spreadsheet users will be prompted to select from the drop-down menu when entering data into that cell. (Note: leave “Ignore blank” checked if you want blank cells to be allowed.) In the source field, type the choices you’d like your drop down menu to include, separated by commas.In the dialog box, select List from the Allow drop-down menu.In this example, lets select the cells C1 To C5. Select the range of cells where you want the dropdown list to be inserted in to. So, let’s enter the values in the range A1 to A3 as shown. Click Data Validation in the drop-down list. First, you need to create a list that you want the drop-down list to be populated with.From the DATA tab, select Data Validation.But for simple situations, it’s a great method. This method works best if you are going to create just a few cells with drop-down lists, because in order to change the choices you would have to modify every cell where it appears. The simplest way to create a drop-down list in Excel 2013/2016 involves listing the choices in a dialog box. Need to add a drop-down list to your spreadsheet? This can be useful for forms, tracking sheets, and more.
0 Comments
Leave a Reply. |