Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Quickly create drop down lists with checkboxes in Excel

Supposing, you have a list of drop down list cells, if you want to select multiple items at once from the drop down list. In fact, you can add checkboxes to the dropdown list, so that you can check the items that you want to add simultaneously. This article, I will introduce Kutools for Excel’s Drop-down List with Check Boxes feature, with this amazing utility, you can quickly create drop down lists with checkboxes for selecting multiple items each time.

Create drop down lists with checkboxes for selecting multiple items at once


Create drop down lists with checkboxes for selecting multiple items at once

To apply this Drop-down List with Check Boxes feature correctly, please do with the following steps:

1. First, you should create the drop down list cells that you want to use.

2. And then, click Kutools > Drop-down List > Drop-down List with Check Boxes > Settings, see screenshot:

3. In the Drop-down List with Check Boxes Settings dialog box, specify the settings as follows:

  • (1.) Specify the scope that you want to apply this feature to. You can select a specified range of cells, Current worksheet, Current workbook or All workbooks as you need.
  • (2.) Choose one style which you want to output the drop down list items from the Mode section. Append means to add the selected items to the end of the values; Modify means the cell value will be changed based on the selection.
  • (3.) Enter a separator into the Separator text box that you want to separate the selected items.
  • (4.) Specify the direction of the selected items under the Text Direction box, you can choose Horizontally or Vertically as you need.

4. After finishing the settings, please click Ok button to exit the dialog box.

5. Now, please click Kutools > Drop-down List > Drop-down List with Check Boxes > Enable Drop-down List with Check Boxes to activate this feature.

6. From now on, when you click the cells with drop down list, a list box with multiple checkboxes will be displayed, you just need to check the items you need from the list box, and the selected items will be output into the cell, see screenshot:

Notes:

1. In the displayed list box:

: Click this button to go to the Drop-down List with Check Boxes Settings dialog box to configure the settings.

: Click this button to clear the cell content.

: Click this button to close the list box temporarily after selecting and displaying the items.

: Click this button to close the list box temporarily and cancel the operation.

2. To disable this feature, you just need to click Kutools > Drop-down List > Drop-down List with Check Boxes > Enable Drop-down List with Check Boxes again to disable this feature.


Quickly create drop down lists with checkboxes in Excel

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no 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 ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.