create drop down list in excel 2010 for mac

Create Drop Down List In Excel 2010 Install It Firstly
Create Drop Down List In Excel 2010 How To Create A

Auto populate other cells when selecting values in Excel drop down list Lets say you have created a drop down list based on the values in cell range B8:B14.

How to make multiple selections from the drop-down list as below screenshot shown The methods in this article can help you solve the problem.

Create drop down list with multiple selections with VBA code Easily create drop down list with multiple selections with an amazing tool More tutorial for drop down list.

Create drop down list with multiple selections with VBA code You can apply the below VBA code to make multiple selections from the drop-down list in a worksheet in Excel.

Please do as follows.

In the Microsoft Visual Basic for Applications window, copy the below VBA code into the code window.

See screenshot: VBA code: drop down list with multiple selections Private Sub WorksheetChange(ByVal Target As Range).

End Sub 3. Press the Alt Q keys to close the Microsoft Visual Basic for Applications window.

Now you can select multiple items from the drop-down list in current worksheet.

Notes: 1. Duplicate values do not allow in the drop-down list.

When closing the workbook, the VBA code will be removed automatically, and the multiple selection is unusable anymore.

Please save the workbook as an Excel Macro-Enabled Workbook in order to keep the code working in the future.

Easily create drop down list with multiple selections with an amazing tool Here highly recommended the Multi-select Drop-down List feature of Kutools for Excel for you.

With this feature, you can easily select multiple items from the drop-down list in a specified range, current worksheet, current workbook or all opened workbooks as you need.

Create Drop Down List In Excel 2010 Install It Firstly

Before applying Kutools for Excel, please download and install it firstly.

Click Kutools Drop-down List Multi-select Drop-down List Settings.

See screenshot: 2.

In the Multi-select Drop-down List Settings dialog box, please configure as follows.

Specify the applying scope in the Apply to section.

In this case, I select Current worksheet from the Specified Scope drop-down list; 2.2) In the Text Direction section, select an text direction based on your needs; 2.3) In the Separator box, enter a delimiter which you will use to separate the multiple values; 2.4) Check the Do not add duplicates box in the Options section if you dont want to make duplicates in drop-down list cells; 2.5) Click the OK button.

See screenshot: 3.

Please click Kutools Drop-down List Multi-select Drop-down List to enable the feature.

Now you can select multiple items from the drop-down list in current worksheet or any scope you have specified in step 2.

If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.

Related articles: Autocomplete when typing in Excel drop down list If you have a data validation drop down list with large values, you need to scroll down in the list just for finding the proper one, or type the whole word into the list box directly.

If there is method for allowing to auto complete when typing the first letter in the drop down list, everything will become easier.

Create Drop Down List In Excel 2010 How To Create A

But if the list data you need for the data validation locates in another workbook, what would you do In this tutorial, you will learn how to create a drop fown list from another workbook in Excel in details.

Create a searchable drop down list in Excel For a drop down list with numerous values, finding a proper one is not an easy work.

Previously we have introduced a method of auto completing drop down list when enter the first letter into the drop down box.

Besides the autocomplete function, you can also make the drop down list searchable for enhancing the working efficiency in finding proper values in the drop down list.

For making drop down list searchable, try the method in this tutorial.

Create Drop Down List In Excel 2010 For Mac