how to make a drop down menu in excel 2016

Select the cell or cells you want the drop-down list to appear in.

Click on the Data tab on Excel’s ribbon.Click on the Data Validation button in the Data Tools group.In the Data Validation dialog, in the Allow: list select List 1) Open Drop Down Menu software and click 'Add item' and 'Add submenu' buttons situated on the Drop Down Menu Toolbar to create your menu.#How to extend drop down menu in excel 2016 software You can also use 'Delete item' to delete some buttons.Press F3 on your keyboard to open the Paste Name dialog.Select the name you gave your list in Step 1īy default a drop-down list will only allow you to select one item.STEP3: Add the VBA Code to Your Drop-Down List To remedy this, paste this formula in Name Manager. This is found under Formulas > Name Manager. The Name Manager will pop up and display the three tables. To add the VBA (visual basic for applications) code to your drop-down list follow these steps: Give the formula a new name and paste the formula in the last text box.Use the keyboard shortcut ALT F11 to open the Visual Basic Editor (VBE).Make sure the Project Explorer is visible – it displays all the workbook’s worksheet names.If you can’t see it, use the keyboard shortcut CTRL R to open it.In the Project Explorer select the worksheet that contains your drop-down list.In the Code window (that’s the big white area to the right of the Project Explorer), paste the code included in the downloadable workbook (see form above to download the workbook).

Close the VBE and you should find that you can select multiple items in your drop-down list.There are a few tweaks to the code that you make and I go through these in the video. #How to extend drop down menu in excel 2016 code One thing you should note is that the code, as it is, assumes you drop-down is in cell A2. If it isn’t, change the range address in line 6. #How to extend drop down menu in excel 2016 download.#How to extend drop down menu in excel 2016 code.#How to extend drop down menu in excel 2016 software.

How to make a drop down menu in excel 2016