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.


Download Practice Workbook


3 Easy Ways to Resize Checkbox in Excel

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.

3 Easy Ways to Resize Checkbox in Excel


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.

Use of View Tab to Resize Checkbox in Excel

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

Use of View Tab to Resize Checkbox in Excel

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.

Use of View Tab to Resize Checkbox in Excel

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.

Use of View Tab to Resize Checkbox in Excel

  • Finally, you will get checkbox in all the cells.

  • Now, check the checkboxes as per your data.

Use of View Tab to Resize Checkbox in Excel


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.

Use of View Tab to Resize Checkbox in Excel

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.

Use of View Tab to Resize Checkbox in Excel

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.

Use of View Tab to Resize Checkbox in Excel

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

Employing Format Control Command to Resize Checkbox in Excel

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

Employing Format Control Command to Resize Checkbox in Excel

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.

Employing Format Control Command to Resize Checkbox in Excel

  • Finally, you will get checkbox in all the cells.

  • Now, check the checkboxes as per your data.

Employing Format Control Command to Resize Checkbox in Excel


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.

Employing Format Control Command to Resize Checkbox in Excel

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 (2 Methods)


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.

Using VBA to Resize Checkbox in Excel

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

Using VBA to Resize Checkbox in Excel

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.

Using VBA to Resize Checkbox in Excel

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.

Using VBA to Resize Checkbox in Excel

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

Using VBA to Resize Checkbox in Excel

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

Using VBA to Resize Checkbox in Excel

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.

Using VBA to Resize Checkbox in Excel

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.

Using VBA to Resize Checkbox in Excel

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 VBA to Resize Checkbox in Excel

Read More: Excel VBA: Form Control Checkbox Value (3 Examples)


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.

Using Size Feature to Resize Checkbox in Excel

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.


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.


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. To get more articles like this visit ExcelDemy. 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

Mashhura

Mashhura

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo