Skip to main content

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?

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


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!
Comments (51)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thanks for the tips, could help me , I am trying to select multiple checkboxes and based on selection count should be displayed. could help me with macro code for same
This comment was minimized by the moderator on the site
Hello, Rohit,

May be the following article can help you, please view it.
https://www.extendoffice.com/documents/excel/2460-excel-sum-count-checkboxes.html

Hope it can help you!
This comment was minimized by the moderator on the site
Hello and thank you for the tips above. Note that in your Sub, you must declare the variable xTitleId with Dim xTitleId as String.. otherwise the routine will produce an error, assuming the user has VBA set with Option Explicit. The Dim above solves the problem and the Sub works perfectly thereafter. Thanks for the great advice and information.
This comment was minimized by the moderator on the site
Great macro, gracefully written!!! Thank you!
This comment was minimized by the moderator on the site
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?
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
Why is my name in this list? I did not take this class.
This comment was minimized by the moderator on the site
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
This comment was minimized by the moderator on the site
Really good macro How do insert them already checked? i.e. their value is already 1? Thanks
This comment was minimized by the moderator on the site
THANK YOU!!! Great post!
This comment was minimized by the moderator on the site
Hello, this macro is a GREAT timesaver - thank you! I'm terrible with VBA, but I was trying to determine which line(s) in the code I may be able to comment to keep the range-reminder dialog from appearing. Is that possible? I'm prepping some checklists for our marketing group and entering a MILLION checkboxes (so you can imagine how much this macro helps), but I have to stop with each group/range and click on that darn dialog. Any way to disable it so I can maybe re-enable it later? Thanks for any help! -LLD
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations