Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

Kutools for Excel 25.00 HOT

300+ Powerful Features You Must Have in Excel

Kutools-for-Excel

Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color and so on. 300+ powerful features / functions for Excel 2019, 2016, 2013, 2010, 2007 or Office 365!

Read More Download Buy now

Office Tab 14.10HOT

Adding Tabbed Interface for Office

Office Tab

It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser IE 8/9/10, Firefox, and Google Chrome. It's compatible with Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo

Read More Download Buy now

Kutools for Outlook 14.00NEW

100+ Powerful Features for Outlook

Kutools-for-Outlook

Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook 2019, 2016, 2013, 2010 or Office 365!

Read More Download Buy now

Kutools for Word  10.00NEW

100+ Powerful Features for Word

Kutools-for-Word

Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365!

Read More Download Buy now

Classic Menu for Office

Bringing Back Your Familiar Menus

Restores the old look and menus of Office 2003 to Microsoft Office 2019, 2016, 2013, 2010, 2007 or Office 365. Don’t lose time in finding commands on the new Ribbon. Easy to deploy to all computers in enterprises and organizations.

Read More Download Buy now

Quickly select multiple items from drop-down lists in Excel

If you have set data validation (drop-down list) for a cell, you can select one item from the drop-down list only. And if you select an item from the drop-down list again, the item selected later will overwrite the existing one. Is it able to append lately selected items, and make multiple selections from the drop-down list? Yes, the Multi-select Drop-down List feature of Kutools for Excel brings you a choice.

Select one item in one cell Select multiple items in one cell
shot drop down list multiple selections 03   shot drop down list multiple selections 03

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Multi-select drop down list settings

If you use the Multi-select Drop-down List utility for first time, you need set the Settings firstly.

Click Kutools > Drop-down List > Multi-select Drop-down List > Settings.
shot drop down list multiple selections 03

In the Multi-select Drop-down List Settings dialog, please configure below options:

1) In Apply to section, you can decide which ranges or sheets, workbooks the Multi-select Drop-down list effects.

Specified Ranges: only work at the selected ranges of the current sheet.

Specified Scope: the utility works at the current sheet, current workbook, or all workbooks you opened based on the choose from the drop-down menu.

2) In Text Direction section, you can choose displaying the multi-items horizontally or vertically in the cell.

Display horizontally Display vertically
shot drop down list multiple selections 03   shot drop down list multiple selections 03

3) In Separator section, type the delimiter you want to separate the items in a cell.

4) In Options section, decide the operation about duplicate items in a cell.

Do not add duplicates: tick this checkbox only, the duplicated item cannot be added to the cell. But the existed ones can be kept.

Remove Duplicates: tick this checkbox, the duplicated item cannot be added to the cell, and at the same time, the existed one will be removed onces time by one click.

Do not add duplicate Remove Duplicates
shot drop down list multiple selections 03  shot drop down list multiple selections 03

Click Ok to finish the settings.


Enable Multi-select Drop-down list feature

After settings, you need to enable the Multi-select Drop-down list feature to take the settings effect.

Click Kutools > Drop-down List > Multi-select Drop-down List, you can see a tick before the tab.
shot drop down list multiple selections 03

Now you can select multiple items in the drop-down list in your specified scope or ranges.


 Notes

1) This Multi-select Drop-down List feature will keep turning on after closing the workbook.

2) You can apply the Clear Data Validation Restrictions feature of Kutools for Excel to clear the data validation of drop-down lists from selections.

3) If you have opened the Multi-select Drop-down List Settings dialog and specified the applying range before, it will automatically specify the same applying range in the Apply to section when you open the dialog next time.

4) If there is no drop-down list existed in your specified ranges or scope, you need to create a drop-down list first, otherwise, you cannot apply the Multi-select Drop-down List feature. The feature Create simple drop-down list can help you quickly create a simple drop-down list to test this feature.

5) The Multi-select Drop-down List feature works when Kutools for Excel installed.


 Demo:Select multiple items from drop-down lists in Excel


Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Kapil · 1 years ago
    Tried drop down - multilple selections feature in excel 2019. It didn't work

Feature Tutorials