Note: The other languages of the website are Google-translated. Back to English

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


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


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 checkboxes 10

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!


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()
'Updateby Extendoffice
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 300 handy Excel add-ins, free to try with no limitation in 30 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 300 handy Excel add-ins, free to try with no limitation in 30 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 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

Related Article:

How to quickly delete multiple checkboxes in Excel?


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (51)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Excellent macro that works beautifully to quickly and easily insert check boxes into a selected range; thank you. Would you consider showing an example of a macro to insert in a selected range a customized drop down list with three options: "Yes", "No", and "Maybe"?
This comment was minimized by the moderator on the site
Great trick... I enjoyed it.
This comment was minimized by the moderator on the site
Why is there only one boy in this class????
This comment was minimized by the moderator on the site
[quote]Why is there only one boy in this class????By Daniel[/quote] :lol: That's just for demonstration.
This comment was minimized by the moderator on the site
excellent macro works add checkbox in the cell, thank u :-)
This comment was minimized by the moderator on the site
Excellent work. Thank you :roll:
This comment was minimized by the moderator on the site
AWESOME! Thank you so much!
This comment was minimized by the moderator on the site
When I did this, everything worked great (Thank you!) except when the boxes are checked, it automatically has a yellow fill color in the cell. How do I make it to where the only thing that happens is the box is checked, no fill color? Thanks!
This comment was minimized by the moderator on the site
[quote]When I did this, everything worked great (Thank you!) except when the boxes are checked, it automatically has a yellow fill color in the cell. How do I make it to where the only thing that happens is the box is checked, no fill color? Thanks!By # Sean[/quote] Just change the line like it says in the comments: .FormatConditions(1).Interior.ColorIndex = 6 'change for other color when ticked Leave it out completely if you don't want a color change. Cheers!
This comment was minimized by the moderator on the site
I did it but when I check one boc, all are being checked together. how can I separate them?
This comment was minimized by the moderator on the site
The code works great! I edit the color now I'd like to center the checkboxes in each cell, any idea what I would need to modify for that? Thanks!
This comment was minimized by the moderator on the site
[quote]The code works great! I edit the color now I'd like to center the checkboxes in each cell, any idea what I would need to modify for that? Thanks!By Violet[/quote] For Each Rng In WorkRng With Ws.CheckBoxes.Add((Rng.Offset(0, 1).Left - Rng.Left) / 2 + Rng.Left - CkBoxSize, Rng.Top, 0.33, Rng.Height) .Characters.Text = Rng.Value End With
This comment was minimized by the moderator on the site
It keeps giving me an error when I open it that it had to fix errors? Any assistance? If someone would like to help I will post the report that I'm getting from Microsoft office.
This comment was minimized by the moderator on the site
The check boxes go a bit nuts when you copy them with their linked cells. I had to write a thing to reset the linking for when I want to copy those cells somewhere else.
This comment was minimized by the moderator on the site
Can we then filter on those check boxes? Basically display only those who attended?
This comment was minimized by the moderator on the site
Can we then filter those check boxes? Basically display only those who attended?
This comment was minimized by the moderator on the site
Yeah totally. The checkboxes are actually independent of the cells. They basically float over the spreadsheet and are linked to a cell by address inserting True and False values when clicked (or N/A if you make it a three-state checkbox). But when you filter in excel it hides specific rows. It will not hide the check boxes. I really don't suggest filtering with this macro. Strange things will happen and you might not realize when there are several check boxes sitting on top of each other or that two check boxes are linked to one cell and a cell is linked to no checkboxes. What I usually do is I will create a list and instead of checkmarks I will type a 1 or a 0 into the adjacent cell and then total. You can even pivot table the thing if your information gets complicated. For instance say you had another column that had the gender of your attendees. You could figure out how many men and how many women attended.
This comment was minimized by the moderator on the site
Thanks a lot!, for check box.
This comment was minimized by the moderator on the site
Is there a way to have the checkbox text be the text of the selected cell?
This comment was minimized by the moderator on the site
Yes. Yes, there is. There is always a way.
This comment was minimized by the moderator on the site
[quote]Yes. Yes, there is. There is always a way.By Danny[/quote] OK. How would I accomplish this. I am not well versed in excel syntax. I have tried .text and .value (for c in the above code). With incorrect results. I have tried a myriad of things that would normally be the result but no luck. What I have is a large bullet list of items that I would like to replace the bullet with a check box and have the value and text of that box be the original text of the bullet item
This comment was minimized by the moderator on the site
Hey guys, this is so helpful - thanks! Quick question, I'm completely inexperienced with this type of stuff so sorry if it's a stupid one! I would like to just have tick boxes (without the true or false) and I would like the boxes to be yellow when not ticked but have no fill once ticked, to indicate students who have not handed in drafts and assessment, etc. Is this possible? Could someone please post the actual code for this, or walk me through it? Many thanks in advance!!!
This comment was minimized by the moderator on the site
how to change the reference address for multiple checkboxes
This comment was minimized by the moderator on the site
I have a excel spreadsheet that has a question and then to the right are other columns "Controls Met, column f and G with check boxes that have been check, column F yes or column G no. I only want to use the filter to get each of the rolls that have a check mark, but the filter does not see s check mark
This comment was minimized by the moderator on the site
how to change cell address
This comment was minimized by the moderator on the site
Sub RelinkCheckBoxes() 'You select cells that include the checkboxes that are acting weird. 'Then you run the macro. 'It changes those checkboxes so that the linked cells correspond to the cells underneath. 'Also it makes the checkbox text turn into the cell text. Dim ckbox As Shape Dim rngLinkedCell As Range If ActiveSheet.CheckBoxes.Count = 0 Then Exit Sub 'Test that selection is a range. If TypeName(Selection) "Range" Then Exit Sub For Each ckbox In ActiveSheet.Shapes 'Test that the shape is a control. If ckbox.Type = msoFormControl Then 'test that the control is a checkbox If ckbox.FormControlType = xlCheckBox Then 'find the cell under the checkbox that is within the selection Set rngLinkedCell = Application.Intersect(ckbox.TopLeftCell, Selection) 'assign a new link address and rename the checkbox to match. If Not rngLinkedCell Is Nothing Then With ckbox .OLEFormat.Object.LinkedCell = rngLinkedCell.Address .Name = rngLinkedCell.Address .TextFrame.Characters.Text = rngLinkedCell.Text End With End If End If End If Next
This comment was minimized by the moderator on the site
The code worked great. Thank you!
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations