Hello Geeky, so today we are focusing on How to Add Checkboxes in MS Excel. So please read this tutorial carefully so you may comprehend it in a better helpful way.
Guide: How to Add Checkboxes in MS Excel
This article explains how to add the Developer tab to the strip, how to add single or different checkboxes, and how to delete a checkbox. Directions apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel for Microsoft 365, and Excel for the web. Microsoft Excel is an incredible tool that provides the user with loads of intuitive choices. One such feature is the Checkboxes in Excel. A checkbox is an interactive tool that permits users to choose or deselect a choice.
There are various ways of monitoring track of tasks in Excel. Possibly you put a X toward the finish of a column or something almost identical. Nonetheless, if you have a sheet that you or others need to over and over scratch off, a checkbox is simpler and more expert. Here’s the means by which to insert a checkbox in Excel.
The checkbox feature is really in the Developer tab, which you’ll have to actuate. We’ll begin with a couple of fast steps on the best way to do that.
Activate developer tab in Excel
If there is no Developer tab on your ribbon, activating it is quite simple. Just follow these steps:
- Right click on any of the tabs in the ribbon. Select Customize the Ribbon. It will open up the Excel Options dialog box.
- In the Excel Options dialog box, you will see Customize the Ribbon to the right. From the Main Tabs selection options, check the Developer option and click OK.
- The Developer tab will now show up on the ribbon.
How to insert a checkbox in Excel
To add a checkbox:
- Go to the Developer tab on the ribbon.
- Click on the Insert dropdown menu.
- Under Form Controls, click the checkbox icon (a square with a blue checkmark)
- Click anywhere in the worksheet, and Excel will insert a checkbox at that location. Your first box will have the default Caption Name “Check Box 1” next to the box as shown on the worksheet below.
- Excel also creates a Backend Name which is shown in the Name Box.
To remove the caption name text (Check Box 1): right click the checkbox, select Edit Text in the context menu, highlight the text, then delete.
How to insert multiple checkboxes in Excel
To insert multiple checkboxes in Excel, insert the first checkbox. Then you can either:
- Select the checkbox and press Ctrl + D (to duplicate and paste). This will place the new box at a location close to the previous checkbox, or
- Select the checkbox and press Ctrl + C (to copy). Then go to the cell where you would like the new checkbox to be and press Ctrl + V (to paste), or
- To copy a checkbox into adjacent cells, use the keyboard arrow keys to select the cell containing the checkbox (don’t select the checkbox itself). Drag the fill handle at the lower right-hand corner of the cell in the direction you want the new checkboxes to appear.
Although the copied boxes appear with the same caption names as the original box, a unique backend name is created for each box.
How to control checkbox size and position
- If you drag on the checkbox object handlebars, you will resize the object frame, but alas! This won’t resize the checkbox itself. It is unfortunate and a little odd, frankly, that this cannot be done in Excel — at least, not right now. The box size on the Excel worksheet is pretty much fixed.
- To fix the position of a checkbox in the sheet from the cells, right-click the checkbox, then click Format Control from the context menu. From the Format Control window, select Don’t move or size with cells from the Properties tab.
How to delete a checkbox
To delete a single checkbox, press the Ctrl key then select the checkbox. Press the Delete key on your keyboard.
To delete multiple checkboxes, select them all by clicking them all while holding down the Ctrl key. Then press the Delete key on your keyboard.
To delete all checkboxes on a worksheet:
- Go to the Home tab.
- From the Editing group, click the Find & Select dropdown.
- Choose Go To Special.
- Select the Objects radio button and click OK.
This will select all the checkboxes on the active sheet. Press the Delete key to remove them all.
How to link a checkbox to a cell
If your checkboxes are not linked to a cell, they’re just looking pretty on your worksheet. You need to put them to work for you. To do this, we have to link each checkbox to a cell which will keep track of whether the box is checked or not.
In the following task list, we want to keep track of how many of the nine required tasks are completed.
- To select the checkbox in cell B2, press the Ctrl key, and click on the checkbox.
- Click in the Formula Bar, and type an equal sign (=).
- Click on cell C2 (if that’s where you want the TRUE/FALSE result for that checkbox to appear) and press Enter.
- Repeat this process for each checkbox, clicking on the respective result cell for each. Note that the link for each checkbox must be created manually, one by one.
Linked cells will now show TRUE when its box is checked, and FALSE when unchecked.
Count the number of completed tasks
- You can count the number of completed tasks with a simple COUNTIF formula. Even if you plan to hide the column with the linked cells, you can make reference to them in any cell you choose.
- The formula in cell B11 counts all cells in the range C2 to C10 which have the logical result TRUE.
Use conditional formatting with checkboxes
We can also get Excel to take special action (for example, change font color, strikethrough, etc.) when a box is ticked. Let’s combine our organization’s to-do list with conditional formatting.
Maybe we want the task to have a strikethrough format when the corresponding checkbox is ticked. Here’s how to do that:
- Select cell A2 and click the Conditional Formatting dropdown menu from the Home tab. Select New Rule.
- From the New Formatting Rule window, select the rule type Use a formula to determine which cells to format.
- In the Edit the Rule Description field, type =C2, then click the Format… button.
- From the Format Cells window, click the Strikethrough checkbox and press OK on the Format Cells and New Formatting Rule windows.
Quickly copy this formatting rule to the other items on the list by using the Format Painter (see below). Any box that is checked will have the strikethrough format applied to its corresponding task. This is just one example of how conditional formatting can be used to enhance Excel’s checkbox capabilities.
Guide about How to Add Checkboxes in MS Excel
In this guide, we told you about the How to Add Checkboxes in MS Excel; please read all steps above so that you understand How to Add Checkboxes in MS Excel in case if you need any assistance from us, then contact us.
How this tutorial or guide assisting you?
So in this guide, we discuss the How to Add Checkboxes in MS Excel, which undoubtedly benefits you.
I hope you like the guide How to Add Checkboxes in MS Excel. In case if you have any queries regards this article/tutorial you may ask us. Also, please share your love by sharing this article with your friends and family.