Checkboxes are often used while working with Excel. The main focus of this article is to explain how to resize checkbox in Excel. Here, I will show 3 easy methods by which you can resize checkbox in Excel.
How to Resize Checkbox in Excel: 3 Easy Ways
To explain this article I have taken the following dataset which is a Daily Tasks Checklist. The dataset contains Tasks and Status. I will resize the checkbox in 3 different methods.
1. Use of View Tab to Resize Checkbox in Excel
In this 1st method, I will show you how to resize checkbox in Excel using the View tab.
Let’s see the steps.
Step-01: Adding Checkbox in Excel
In this 1st step, I will explain how to add a checkbox in Excel.
- Firstly, go to the Developer tab.
- Secondly, select Insert.
Now, you will see a drop-down menu.
- After that, select Checkbox from Form Controls.
- Now, draw a checkbox in the cell where you want the checkbox like the following image. Here, I drew in cell C6.
At this point, you will see that you have inserted your checkbox.
Now, I will show how you can edit the text of the checkbox.
- Firstly, Right-click on the checkbox.
- Secondly, select Edit Text.
- After that, edit the text as you want. Here, I only kept the checkbox and deleted the text.
Next, you can copy the checkbox to all the other cells.
- Firstly, select the cell that contains the checkbox.
- Secondly, drag the Fill Handle to copy the checkbox.
- Finally, you will get checkbox in all the cells.
- Now, check the checkboxes as per your data.
Step-02: Using Zoom Feature
In this step, I will show you how to resize checkbox in Excel using the View tab.
- Firstly, go to the View tab from the Ribbon.
- Secondly, select Zoom.
Now, you will get the Zoom options.
- Firstly, select the zoom percentage you want. Here, I selected 160%.
- Secondly, select OK.
Now, you will see that the checkboxes have been resized.
After that, you will have to adjust the rest of your dataset accordingly. To begin with, I will change the Row Height.
- Firstly, click on the marked portion to select the whole worksheet.
- Secondly, go to the Home tab.
- Thirdly, select Format from Cells.
Now, you will get a drop-down menu.
- After that, select Row Height.
Here, the Row Height option will appear.
- Firstly, select the Row height as you want. Here, I kept it 12.
- Secondly, select OK.
- After that, change the font size of the texts accordingly and you will get your desired dataset.
Here, in the following image, you can see that I have resized the checkbox successfully.
Read More: What Can You Do with Cell Value If Checkbox Is Checked in Excel?
2. Employing Format Control Command to Resize Checkbox in Excel
In this method, I will show you how to resize checkbox in Excel using the Format Control command.
Let’s see the steps.
Step-01: Adding Checkbox in Excel
In this step, I will explain how to add checkbox in Excel.
- Firstly, go to the Developer tab.
- Secondly, select Insert.
Now, you will see a drop-down menu.
- Thirdly, select the Checkbox from ActiveX Controls.
- After that, draw a checkbox in the cell where you want the checkbox like the following image. Here, I drew in cell C6.
Here, you will see that you have inserted your checkbox.
Now, I will show how you can edit the text of the checkbox.
- Firstly, Right-click on the checkbox.
- Secondly, select CheckBox Object.
Here, you will see a drop-down menu.
- Thirdly, select Edit.
- Now, edit the text as you want. Here, I edited it as you can see in the following image.
After that, you can copy the checkbox to all the other cells.
- Firstly, select the cell that contains the checkbox.
- Secondly, drag the Fill Handle to copy the checkbox.
- Finally, you will get checkbox in all the cells.
- Now, check the checkboxes as per your data.
Step-02: Use of Format Control Command
In this step, I will explain how to resize checkbox in Excel using the Format Control command.
- Firstly, Right-click on the checkbox.
- Secondly, select Format Control.
Then, a dialog box will appear.
- Firstly, go to Properties.
- Secondly, select Move and size with cells.
- Thirdly, select OK.
- Now, resize the cells to resize checkbox.
In the following image, you can see that I have resized my checkboxes.
Read More: Excel Checkbox: If Checked then Change Cell Color
Similar Readings
- How to Align Checkboxes in Excel
- How to Add Checkbox in Excel without Using Developer Tab
- VBA to Check If CheckBox Is Checked in Excel
3. Using VBA to Resize Checkbox in Excel
In this method, I will explain how to resize checkbox in Excel using VBA.
Let’s see the steps.
Step-01: Inserting Checkbox in Excel
In this step, I will show you how to insert checkbox into your worksheet.
- Firstly, select a cell in your worksheet which is not in your dataset. Here, I selected cell F1.
Here, a drop-down menu will appear.
- After that, select Symbol from that drop-down menu.
Now, a dialog box will appear.
- Firstly, go to Symbols.
- Secondly, change the Font to Wingdings.
- After that, select the marked Symbol which is an empty checkbox.
- Next, select Inset.
Now, you will see the empty checkbox has been inserted into your selected cell.
- After that, select another cell in your worksheet which is not in your dataset. Here, I selected cell G1.
Here, follow the same procedure from Step-01 of Method-3 to bring the following dialog box to your screen.
- Now, select the marked Symbol which is a checked checkbox.
- After that, select Insert.
Now, you will see the checked checkbox has been inserted into your selected cell.
After that, you will have to copy the empty checkbox to four other cells.
- Firstly, select the cell that contains the empty checkbox.
- Secondly, drag the Fill Handle to copy the checkbox.
- Finally, you will get empty checkboxes in five cells.
- After that, copy an empty checkbox in cell G2.
Step-02: Using VBA Code
In this step, I will show you how to resize checkbox in Excel using VBA code.
- Firstly, go to the Developer tab.
- Secondly, select Visual Basic.
Now, you will see the Visual Basic window has opened.
- After that, go to the Insert tab.Â
- Now, select the Module option.
Here, you will see a Module has opened. In that Module type in the following code.
Sub Resizing_Checkbox(ByRef Index As String)
   If Range("F" & Index).Value = Range("G1").Value Then
   Range("F" & Index).Value = Range("G2").Value
   Else
   Range("F" & Index).Value = Range("G1").Value
   End If   Â
End Sub
Sub CheckBox1()
Call Resizing_Checkbox(1)
End Sub
Sub CheckBox2()
Call Resizing_Checkbox(2)
End Sub
Sub CheckBox3()
Call Resizing_Checkbox(3)
End Sub
Sub CheckBox4()
Call Resizing_Checkbox(4)
End Sub
Sub CheckBox5()
Call Resizing_Checkbox(5)
End Sub
Code Breakdown
- Here, I have created a Sub procedure named Resizing_Checkbox. Then, used Index as String by Reference within the Sub procedure.
- Next, I used an If statement. If the value in the F column matches the value in cell G1. Then, the function returns the value in cell G2. Else, the function will return the value in cell G1.
- Then, I ended the If statement.
- After that, I ended the Sub procedure.
- Next, I created another Sub procedure named CheckBox1.
- After that, I used the Call statement to call Resizing_Checkbox. And used 1 as Index.
- Then, I ended the Sub procedure.
- Now, in the same way, I added 4 more Sub procedure named CheckBox2, CheckBox3, CheckBox4, and  CheckBox5.
- Next, Right-click on the cell where you want your checkbox.
- Then, select Paste Special.
Here, you will get a drop-down menu.
- Now, select Linked Picture.
Finally, you have inserted your checkbox into the cell you want.
- Now, drag the dotted border of the checkbox to resize your checkbox.
Here, you can see that I have resized my checkbox In the following image.
Now, you can crop the extra space.
- Firstly, Right-click on the checkbox.
- Secondly, select Crop.
- Thirdly, Crop the border as per your need.
Now, in the following picture, you can see that I have successfully resized my checkbox.
Here, follow the procedure from Step-02 of Method-03 to copy all the checkboxes.
Now, a dialog box will appear.
- Firstly, select Macro name as ChechBox1.
- Secondly, select OK.
Now, for the second checkbox follow the previous procedure to bring the Assign Macro dialog box to your screen.
- Firstly, select Macro name as ChechBox2.
- Secondly, select OK.
After that, follow the same procedure to Assign Macro to all the checkboxes.
Finally, check the checkboxes as per your data.
Read More: Excel VBA: Form Control Checkbox Value
Using Size Feature to Resize Checkbox in Excel
In this method, I will show you how to resize checkbox in Excel using the Size feature.
Let’s see the steps.
Steps:
- Firstly, Right-click on the checkbox.
- Secondly, select Format Control.
A dialog box named Format Control will appear.
- Firstly, go to Size.
- Secondly, select Lock aspect ratio,
- Thirdly, change the Height as you want. The Width will change automatically according to the Height.
- Finally, select OK.
Now. you will see that only the outer border of the checkbox is resized. But, the actual size of the checkbox remains the same. That’s why the 3 methods that we discussed earlier are more suitable to resize checkbox in Excel.
Read More: How to Remove Checkboxes from Excel
Things to Remember
- It should be noted that whenever working with VBA code you must save the file as Excel Macro-Enabled Workbook. Otherwise, the file will not work.
Practice Section
Here, I have provided a practice sheet for you to practice how to resize checkbox in Excel.
Download Practice Workbook
Conclusion
To conclude, I tried to explain how to resize checkbox in Excel. I covered 3 easy methods. I hope this article was helpful for you. I recommend your practice to understand more clearly. Lastly, If you have any questions feel free to let me know in the comment section below.