How to quickly insert multiple checkboxes in Excel?

How can we quickly insert multiple check boxes in Excel? Please follow these tricky methods in Excel:

Insert multiple checkboxes with Fill Handle

Insert multiple checkboxes with VBA code

Insert multiple checkboxes with Kutools for Excel

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

arrow blue right bubbleInsert multiple checkboxes with Fill Handle

In Excel, Fill Handle is a powerful function to do many things. It can fill the checkboxes as well. First, you must insert a checkbox. Do as follows:

1. Click Developer in the menu bar, then click Insert, and choose the checkbox image under Form Control. See screenshot:

doc-insert-multiple-checkboxes1

2. Click the checkbox image, and you will see plus sign pointer, click where you want to add checkbox.

doc-insert-multiple-checkboxes2

3. Select the check box and move it to a cell, and then delete the name of the checkbox.

4. Then select the cell where the checkbox stay in. And then drag the fill handle over the range of cells that you want to fill. See screenshot:

doc-insert-multiple-checkboxes3


arrow blue right bubbleInsert multiple checkboxes with VBA code

If you think the first method is somewhat troublesome, the following VBA code can help you easily and quickly insert multiple checkboxes.

1. Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following code into the Module:

Sub InsertCheckBoxes()
'Update 20140506
Dim Rng As Range
Dim WorkRng As Range
Dim Ws As Worksheet
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
Set Ws = Application.ActiveSheet
Application.ScreenUpdating = False
For Each Rng In WorkRng
With Ws.CheckBoxes.Add(Rng.Left, Rng.Top, Rng.Width, Rng.Height)
.Characters.Text = Rng.Value
End With
Next
WorkRng.ClearContents
WorkRng.Select
Application.ScreenUpdating = True
End Sub

2. Then click doc-multiply-calculation-3 button to run the code. And a prompt box will pop out to remind you to select a range of cells that you want to insert the checkboxes. See screenshot:

doc-insert-multiple-checkboxes4

3. And then click OK, the checkboxes have been inserted in the range neatly and beautifully. See screenshot:

doc-insert-multiple-checkboxes5


arrow blue right bubbleInsert multiple checkboxes with Kutools for Excel

Here, I can introduce you an easy and handy way to insert multiple checkboxes-Kutools for Excel, with its Batch Insert Check Box feature, you can insert the checkboxes into blank cells or cells with data.

Kutools for Excelincludes more than 120 handy Excel tools. Free to try with no limitation in 30 days.Get it Now.

After installing Kutools for Excel, please do with following steps:

1. Select a range of cells that you want to insert the checkboxes.

2. Click Kutools > Insert Tools > Batch Insert Check Box, see screenshot:

doc-insert-multiple-checkboxes6

3. Then your selected cells have been filled with the checkboxes as following screenshots shown:

Insert checkboxes into blank cellsInsert checkboxes into data cells
doc-insert-multiple-checkboxes7doc-insert-multiple-checkboxes8

To know more about this feature, please go to Batch Insert Check Box.


Related Article:

How to quickly delete multiple checkboxes in Excel?


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh