メインコンテンツへスキップ

Kutools for Excel

300 以上で Excel を強化
強力な機能

Excelのチェックボックスを使用してドロップダウンリストをすばやく作成する

If you're working with drop-down lists in Excel and find yourself limited to selecting only one option per cell, with each new selection replacing the previous one, you may be wondering how to select multiple items at once. The solution? Integrate checkboxes into dropdown lists. Kutools for Excel と呼ばれる機能を提供します チェックボックス付きのドロップダウンリスト that allows you to select multiple items at once by simply checking the checkbox in front of each option. This tool changes the way you interact with drop-down lists, making it easy to add multiple items to a cell.


Advantages of using "Drop-down List with Check Boxes"

  • 複数選択::
    Unlike standard drop-down lists that limit you to one choice per cell, this feature allows for the selection of multiple items in a single cell, enhancing flexibility in data entry and analysis.
  • Quick Item Search Navigation::
    Users can easily find a specific item in a long list by simply typing a keyword in the search box, making navigation and selection faster and more efficient.
  • Customizable Item Separators::
    Users have the freedom to define their own separators between selected items, such as commas, semicolons, spaces, etc...
  • Flexible Display Options: :
    The option to display each checked item on a new line within the same cell adds to the clarity and organization of the data. This is particularly useful when dealing with multiple selections that need to be easily distinguishable at a glance.
  • Efficiency and Time Saving data entry::
    It streamlines the process of entering data, especially when you need to select several options from a long list, significantly reducing the time spent on data entry.
  • ユーザーフレンドリーなインターフェース::
    The intuitive design of checkboxes makes it simple for users of all skill levels to select multiple options without complex workarounds.

Usage of "Drop-down List with Check Boxes"

This section demonstrates the usage of this "Drop-down List with Check Boxes" feature.

Kutools for Excel: Offers more than 300 advanced features to simplify complex Excel tasks, make your work more efficient and productive. 今すぐ 30 日間の無料トライアルをお楽しみください。

  1. に行きます クツール タブ、選択 ドロップダウンリスト > チェックボックス付きのドロップダウンリスト.
    Note: Make sure the checkbox before Enable Advanced Drop-down List is checked, otherwise the Drop-down List with Check Boxes will be grayed out and unavailable.
  2. Add Checkboxes to the Dropdown List dialog box, make the following configurations.
    1. Please select the range containing the dropdown list box, choose the cells with the drop-down list to which you wish to add checkboxes.
    2. セパレータ, enter a delimiter for separating checked items.
    3. OK ボタン。 スクリーンショットを参照してください:
  3. Now, checkboxes have been added to the dropdown list within the specified range. Clicking any cell in this range will display a list box adjacent to it, allowing you to select multiple items by checking the corresponding checkboxes.
ヒント:
  • Wrap Text After Inserting a Separator: If you check this Wrap Text After Inserting a Separator box, selected items will be displayed on separate lines within the cell. If unchecked, items will appear on a single line.
  • 検索を有効にする: If enabled, a search bar appears at the top of the list box, allowing you to easily find items by typing keywords or letters.
  • There are certain icons in the list box:
    • : Click on this 設定 icon will open the Add Checkboxes to the Dropdown List dialog box, where you can reconfigure the settings as needed.
    • : By default, this ピン icon is highlighted (pressed), causing the list box to automatically appear when a drop-down list cell is selected. To prevent automatic pop-up, click the pin icon to unhighlight (release) it.There are certain icons in the list box:
    • : Click on this 閉じる icon will hide the list box.
  • Some shortcuts are available for this feature:
    • スペース: Selecting any item in the list and pressing the Space key will either add or remove that item from the cell.
    • 入力します: Pressing the Enter key will save the selected items in the cell and close the list box.
    • Escキー: Pressing the Esc button will undo the changes in the cell and close the list box.
    • 削除: Pressing the Delete key will clear the cell content.There are certain icons in the list box:
    • Ctrlキー + up/ダウン// key: Pressing Ctrl + up/down/left/right key allows you to move the selected cell up, down, left, or right without closing the list box.
  • The list box can be moved by dragging the blank area on the bottom function bar.
  • Status ピン icon is not pressed, selecting a drop-down list cell with the Drop-down List with Check Boxes feature will show a small box next to it. Click the drop-down arrow within this box to expand the list, or drag the four-sided arrow icon to move the box.

ノート

  1. To remove the Drop-down List with Check Boxes rules, select クツール > ドロップダウンリスト > Advanced Drop-down List Manager. From there, select the rule for Drop-down List with Check Boxes, click 削除、次いで OK to confirm the changes. For more details on using the Advanced Dropdown List Manager, このページにアクセスしてください.
  2. Removing the Drop-down List with Check Boxes rules only affects the checkboxes feature; the original Excel drop-down lists remain functional in your workbook.
  3. This feature is only available if Kutools for Excel is installed.

推奨される生産性ツール
次のツールは時間とお金を大幅に節約できますが、どれがあなたに適していますか?
Office Tab: Officeで便利なタブを使用する、Chrome、Firefox、およびNew InternetExplorerの方法として。
Kutools for Excel: Excel用の300以上の高度な機能 2021、2019、2016、2013、2010、2007、およびOffice365。

Kutools for Excel

上記の機能は、Kutools forExcelの300の強力な機能のXNUMXつにすぎません。

Excel(Office)2021、2019、2016、2013、2010、2007、およびOffice365用に設計されています。無料でダウンロードして30日間使用できます。

Excel用のKutoolsのスクリーンショット

btn続きを読む      btnダウンロード     btn購入

Comments (4)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Sziasztok, engem is az érdekelne, hogy a korábban feltett kérdésekre mi a válasz. Csak ott működik a funkció ahol le van töltve ez az alkalmazás?
Amikor elmentem/bezárom/újra megnyitom a fájlt, nem aktiválja automatikusan! Mi erre a megoldás?
This comment was minimized by the moderator on the site
Hello, Roland,
This feature only works if you have installed Kutools for Excel.
When you quit/close/reopen the file, this feature is activated automatically.

Please download and install the newest version.
https://www.extendoffice.com/download/kutools-for-excel.html
This comment was minimized by the moderator on the site
Hi, [kutools drop down list with checkbox] works when activated. When I save/close/re-open the file, it doesn't activate it automatically. What can be done especially if I am sending the file to someone who doesn't have kutools?
This comment was minimized by the moderator on the site
Id be curious about this as well. If I send this excel to someone does that mean then need to also have the program installed?
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations