How to Resize Checkbox in Excel (3 Easy Ways)

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 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 a Checkbox in all the cells.

• Now, check the Checkboxes as per your data.

Read More: How to Add Checkbox in Excel without Using Developer Tab

Step-02: Using Zoom Feature

In this step, I will show you how to resize the 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.

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 a 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.

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.

• Secondly, go to the Insert tab.
• Thirdly, select Symbols.

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

• Now, Right-click on the cell where you have your first empty Checkbox.
• After that, select Copy.

• 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 it.

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.

• After that, Right-click on the first Checkbox.
• Then, select Assign Macro.

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.

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 for resizing Checkbox in 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 to 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.

Related Articles

• How to Align Checkboxes in Excel
• How to Link Multiple Checkboxes in Excel
• How to Count Checkboxes in Excel
• How to Group Checkboxes in Excel
• How to Filter Checkboxes in Excel
• How to Apply Conditional Formatting Using Checkbox in Excel
• How to Remove Checkboxes from Excel

<< Go Back to Excel CheckBox | Form Control in Excel | Learn Excel