Table of Contents
This tip is about the how to Add Checkboxes in MS Excel. So read this free guide, How to Add Checkboxes in MS Excel step by step. If you have query related to same article you may contact us.
How to Add Checkboxes in MS Excel – Guide
This article explains how to add the Developer tab to the strip, how to add unique or different checkboxes and how to delete a checkbox. The instructions 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 amazing tool that offers the user many intuitive options. Such a feature are the checkboxes in Excel. A checkbox is an interactive tool that allows users to choose or deselect an option.
There are several ways to monitor task tracking in Excel. Possibly you put an X in the final of a column or something almost identical. However, if you have a sheet that you or others need to cross over repeatedly, a checkbox is simpler and more specialized. Here is the way to insert a checkbox into Excel.
The checkbox feature it’s actually in the Developer tab, which you’ll have to act on. We’ll start with some quick steps on the best way to do this.
Activate the developer guide in Excel
If there’s no Developer tab on your ribbon, enabling it is pretty straightforward. Just follow these steps:
How to enter a checkbox in Excel
To add a checkbox:
To remove text from the caption name (Check Box 1): Right-click the check box, select Edit text from the context menu, highlight the text and delete.
How to insert multiple checkboxes in Excel
To insert multiple checkboxes in Excel, insert the first checkbox. So you can:
Although the copied boxes appear with the same caption names as the original box, a unique back-end name is created for each box.
How to control the size and position of the selection box
How to delete a checkbox
To delete a single checkbox, press the Ctrl key and check the checkbox. Press the Delete key on your keyboard.
To delete multiple checkboxes, select them by clicking all of them while holding down the Ctrl key. Then press the Delete key on your keyboard.
To delete all checkboxes in a spreadsheet:
This will check all checkboxes on the active sheet. Press the Delete key to remove them all.
How to link a selection box to a cell
If your checkboxes aren’t linked to a cell, they’ll just look nice on your spreadsheet. You need to put them to work for you. To do this, we have to link each checkbox to a cell that will control whether the checkbox is checked or not.
In the list of tasks below, we want to keep track of how many of the nine required tasks have been completed.
Linked cells will now show TRUE when their box is checked and FALSE when unchecked.
Count the number of completed tasks
Use conditional formatting with checkboxes
We can also make Excel perform a special action (eg change font color, strikethrough, etc.) when a box is checked. Let’s combine our organization’s to-do list with conditional formatting.
We might want the task to have a strikethrough format when the corresponding checkbox is selected. Here it is how to do it:
Quickly copy this formatting rule to the other items in the list using the Formatting Brush (see below). Any box checked will have the strikethrough format applied to the corresponding task. This is just one example of how conditional formatting can be used to enhance Excel’s checkbox capabilities.
Final note
I hope you like the guide How to Add Checkboxes in MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.