How to Insert a Checkbox in Excel (Quick and Easy)
How to Insert a Checkbox in Excel (Quick and Easy)
In this tutorial, we’re going to talk about how to insert a checkbox in Excel in a quick and easy way. Let’s start!
Don’t miss out a great opportunity to learn:
How to Insert Image/Symbol in Excel ► • How to Insert Image/Symbol in Excel
How to Insert Bullet Points in Excel ► • How to Insert Bullet Points in Excel …
Excel Tips \u0026 Tricks for Becoming a Pro ► • How to Insert Image in Excel Cell (Co…
================
⏱️Timestamps⏱️—
0:00 Intro 0:28 How to Insert a Checkbox in Excel 1:45 How to Adjust the Checkbox
================
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :) ► https://www.youtube.com/c/ExcelTutori…
Become a Patron: Do you find our tutorials useful? Chip in to keep us going. You can make a one-off donation with PayPal or support us regularly on YouTube. Thank you! PayPal ► https://www.paypal.com/cgi-bin/webscr… YouTube ► / @exceltutorialseasyclickacademy
1.344 -> In this tutorial, we’re going to talk about how to insert a checkbox in Excel in a quick and easy way.
9.18 -> Let’s start!
14.24 -> Hello! And welcome to EasyClick Academy! My name’s Frank and together with our EasyClick team,
20.44 -> we’re here to make sure you’ll be able to use Excel in a quick and easy way, thanks to our digestible video tutorials.
28.803 -> To insert a checkbox in Excel, we need to make sure that the Developer tab shows on the Ribbon.
34.797 -> So, if you can’t see it, right-click anywhere on the Ribbon and go to ‘Customize the Ribbon’.
41.501 -> You’ll see a pop-up window where you simply tick the Developer box and press OK.
47.151 -> Once done, click on the tab and then click on ‘Insert’ where you’ll find what we’re looking for – the checkbox.
55.569 -> As you can see, Excel offers two sets of controls you can use.
60.437 -> The first set is called ‘Form Controls’ – these are for a simple use, for example if you want to just display a checkbox in a worksheet.
70.551 -> Below are ‘ActiveX Controls’ for a more advanced use – you can customise them in situations when the basic ‘Form Controls’ simply won’t do.
82.705 -> Here we’ll focus on the simple use of ‘Form Controls’, so we’ll select the checkbox from the upper set of controls.
91.516 -> So, click on the checkbox under the ‘Form Controls’ – the cursor changes into a plus sign and we can insert the checkbox wherever we need.
102.147 -> Let’s insert it here and move on.
105.562 -> You can see that there’s a frame around the checkbox, so it’s easy to move the box or change or remove the default text.
114.438 -> But keep in mind that the frame also marks the active area of the checkbox. If you click anywhere within the frame, the box will get ticked or unticked.
125.486 -> Here, the area extends beyond the cell border, so let’s have a look how the checkbox works in this case.
134.2 -> I’m going to click anywhere on the sheet to leave the editing mode of the checkbox.
139.677 -> Now, when I click on the active area, which reaches beyond the checkbox and even the cell borders, the tick appears in the checkbox.
149.12 -> To unselect the checkbox, I need to click one more time.
153.856 -> Okay, this works perfectly well! But the size of the active area can be a bit of a problem here.
160.41 -> That’s why it’s important to make sure that the size of the active area is adjusted as needed.
166.842 -> To edit the checkbox, right-click on it and you’ll see the options for editing. Use these little circles to set the right size of the area.
177.105 -> Once done, you can copy the checkbox to the rest of the rows in the table.
182 -> Simply click on the cell containing the box and drag its bottom right-hand corner down all the rows in which you want to display the checkbox.
193.116 -> To remove the box, right-click on the area again, select the option ‘Cut’ and that’s it!
200.969 -> To learn about how you can add other features like bullet points to your spreadsheets, watch more video tutorials by EasyClick Academy.
209.513 -> The links are in the description below.
212.127 -> If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!
221.493 -> Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!
229.728 -> Thanks for watching and I’ll see you in the next video!
