Перейти к основному содержанию

Быстрый выбор нескольких элементов из раскрывающихся списков в Excel

Kutools for Excel

Повышает Excel с помощью 300+
Мощные функции

If your cell is set with a drop-down list, traditionally, you're limited to selecting a single item at a time. Selecting another item from the same drop-down list replaces the previously chosen one. However, what if you need to select multiple items from that list? Thankfully, the Раскрывающийся список с множественным выбором функцию в Kutools for Excel offers a solution, allowing you to append recently selected items and make multiple selections from a single drop-down list.

???? Advantages of Kutools for Excel's Multi-select Drop-down List ????
  • 🔢 Multiple Selection Capability: Unlike Excel's standard drop-down lists, which restrict users to selecting a single item per cell, Kutools' Multi-select Drop-down List allows for the selection of multiple items within the same cell.
  • 🛠️ Customization and Flexibility: Standard Excel drop-down lists offer limited customization, primarily confined to the list items themselves. In contrast, Kutools allows users to specify delimiters for separating multiple selections and choose between vertical or horizontal item display.
  • ⌨️ Efficient Navigation with Keyboard Shortcuts: Kutools enhances user experience by incorporating keyboard shortcuts for quick navigation and selection within the multi-select drop-down list.
  • 🔍 Integrated Search Functionality: Kutools introduces a search bar within the drop-down list, a feature absent in Excel's standard version. This search functionality allows for quick filtering and selection from lengthy lists, enhancing efficiency and user experience.
  • 🚀 Ease of Use: Beyond its advanced capabilities, the Multi-select Drop-down List feature in Kutools is designed for ease of use, enabling users to quickly set up and implement multi-select lists.

To utilize this feature, follow these steps:

  1. Выберите Кутулс > Раскрывающийся список > Раскрывающийся список с множественным выбором.

    выстрел множественный выбор раскрывающийся список 1

  2. В Раскрывающийся список с множественным выбором диалоговом окне, выполните следующие действия:

    выстрел множественный выбор раскрывающийся список 2

    1. Select the cell range that has the drop-down list applied.
    2. Specify a delimiter to separate the multiple items you will choose.
    3. Проверить Перенос текста после вставки разделителя option if you want to display the selected items vertically within the cell. If you prefer a horizontal listing, leave this option unchecked.
    4. Проверить Включить поиск option if you want to add a search bar to your drop-down list as shown below.

      выстрел множественный выбор раскрывающийся список 3

    5. Complete the setup by clicking OK.

After following these instructions, the drop-down lists within your specified range will now support the selection of multiple items within a single cell, enhancing the flexibility and functionality of your Excel worksheets.

Ноты:

  1. The Multi-select Drop-down List feature includes support for keyboard shortcuts, enhancing ease of use and efficiency when interacting with the drop-down list. Here's how you can utilize shortcuts with the multi-select box:
    • /: Navigate through the items in the drop-down list by using the up arrow (↑) or down arrow (↓) keys. You can also use the Page Up or Page Down keys for quicker navigation. If the search bar is enabled and the cursor is at the top item, pressing the key will move the cursor to the search box, allowing you to type and search for specific items.
    • Esc: Нажатие Esc key will close the multi-select drop-down box without saving any changes made during the current operation in the active cell.
    • +/-: Используйте плюс (+) or minus (−) key to add a located item or remove it from the drop-down list.
    • Enter: Нажмите Enter key to confirm your selections and advance to the cell directly below the currently active one.
    • Tab: Нажмите Tab key to confirm your selections and proceed to the adjacent cell on the right.
  2. If the location of the multi-select drop-down list shifts, the feature will become disabled. For instance, if you initially set up a multi-select drop-down list in column B and later insert a new column between columns A and B, pushing the drop-down list to column C, the multi-select functionality will be deactivated.
  3. The multi-select drop-down list can be moved and resized to fit your needs.

  4. To prevent the multi-select drop-down list from appearing every time you select the corresponding cell, simply unpin it by clicking the pin button located at the lower-right corner of the drop-down list.

  5. By default, the search feature is case-insensitive and will match any character within the items.
  6. To modify an existing multi-select drop-down list, including changing the separator or enabling/disabling the search bar, click on the gear icon.

  7. To stop selecting multiple items in a cell, navigate to Кутулс > Раскрывающийся список > Advanced Dropdown List Manager to delete the corresponding multi-select drop-down lists. For more information, please refer to: Manage Multiple Advanced Drop-down Lists: Edit and Clear.

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


Kutools for Excel: Более 300 удобных инструментов у вас под рукой! Начните 30-дневную бесплатную пробную версию без ограничений сегодня. Скачать

Рекомендуемые инструменты для повышения производительности
Следующие ниже инструменты могут значительно сэкономить ваше время и деньги. Какой из них вам подходит?
Office Tab: Использование удобных вкладок в вашем офисе, как и в случае Chrome, Firefox и New Internet Explorer.
Kutools for Excel: Более 300 дополнительных функций для Excel 2021, 2019, 2016, 2013, 2010, 2007 и Office 365.

Kutools for Excel

Описанная выше функциональность - лишь одна из 300 мощных функций Kutools for Excel.

Предназначен для Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 и Office 365. Бесплатно скачать и использовать в течение 30 дней.

Снимок экрана Kutools for Excel

btn подробнее      btn скачать     покупка btn

 

Comments (3)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
This feature no longer works in the newest version of Excel, and so far ExtendOffice's support has not been helpful. There is some kind of data validation conflict with setting up lists now.
This comment was minimized by the moderator on the site
Hi there,

Please attach specific screenshots of the settings in this feature window as well as the screenshots of Excel's built-in data validation settings you have applied for reference.

If you have trouble attaching pictures here, please send a message to
This comment was minimized by the moderator on the site
Tried drop down - multilple selections feature in excel 2019. It didn't work
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations