Log in
x
or
x
x
Register
x

or
0
0
0
s2smodern

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 and delete multiple checkboxes with one click by using Kutools for Excel


Insert multiple checkboxes in selections with one click:

Kutools for Excel's Batch Insert Check Boxes utility can help you to quickly insert multiple checkboxes at once. Click to free download this feature.

doc-insert-multiple-checkboxes1

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


arrow blue right bubble Insert 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 bubble Insert 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 bubble Insert 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 Excel : with more than 120 handy Excel add-ins, free to try with no limitation in 60 days.

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 > Batch Insert Check Boxes, see screenshot:

doc-insert-multiple-checkboxes06

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

Insert checkboxes into blank cells Insert checkboxes into data cells
doc-insert-multiple-checkboxes7 doc-insert-multiple-checkboxes8

Tips. If you want to quickly delete multiple checkboxes, please try to use the Kutools for Excel’s Delete Check Boxes as shown in the following screenshot. It’s full function without limitation in 60 days, please download and have a free trial now.

doc-insert-multiple-checkboxes9

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


arrow blue right bubble Insert and delete multiple checkboxes with Kutools for Excel

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Related Article:

How to quickly delete multiple checkboxes in Excel?


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

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.
  • To post as a guest, your comment is unpublished.
    Tianao Li · 4 months ago
    Great macro, gracefully written!!! Thank you!
  • To post as a guest, your comment is unpublished.
    Jeff · 5 months ago
    I just purchased the program. When I insert the checkboxes, they are slightly lower than the cell itself, so they are encroaching into the cell below. How can I reposition each of those cells?
  • To post as a guest, your comment is unpublished.
    Nesh · 1 years ago
    Hye there. im new here n new for using excel.can i know how to put other excel sheet under one excel sheet. example when i open 1 excel sheet and i got my audit plan. Then i got list of country overall such as Canada and Belgium. So what i wan to know how if i click Canada and my audit plan for Canada will appear.
  • To post as a guest, your comment is unpublished.
    Ruby Lee · 2 years ago
    Why is my name in this list? I did not take this class.
  • To post as a guest, your comment is unpublished.
    sam · 2 years ago
    Hi Just followed your code to create a list of checkboxes on my spreadsheet, I am very new to this but have managed to follow it and worked perfectly. I just cant remove the checkbox labels coming up? i have a pretty long spreadsheet and deleting them individually is impossible. can i remove the labels that come up with each checkbox??? please help