Excel is a potent programme that gives the user with numerous interactive possibilities. Checkboxes are one such feature in Excel. A checkbox is an interactive element that enables users to choose or deselect an option.
How to Get the Developer Tab in the Excel Ribbon?
The first step in inserting the checkbox is to reveal the developer tab, which is normally buried on the Excel ribbon. To add the developer tab to Excel’s ribbon, perform the steps below:
- Right-click anywhere on the ribbon and select Customize the Ribbon.
- Under Customize the Ribbon, check the Developer box and click OK.
Also Read: How to Turn Off Flashlight On iphone 12?
How to Insert a Checkbox in Excel?
The first step in establishing an Excel checklist is to compile a list of the chores or other things for which checkboxes will be put.
To insert a checkbox in Excel, execute the following steps:
- Step 1: Go to Developer Tab —> Controls —> Insert —> Form Controls —> Check Box.
- Step 2: Click in the cell where you want to insert the first checkbox (F4 in our example).
- Step 3: Position the checkbox by dragging it. To remove the text “Check Box 1”, right-click the check box, select Edit Text in the context menu, and then delete the text.
Your first checkbox is ready.
Copy the Checkbox to other Cells
Drag the checkbox cells to all the below cells to copy them.
Link a Checkbox to a Cell
To capture the status (checked or unchecked) of a checkbox, you need to link the checkbox to a particular cell. To do this, execute these steps:
- Right-click on the checkbox and select Format Control.
- In the Format Control dialog box, make the following changes, and click OK.
- Value: Checked. This makes sure that the checkbox is checked by default when you open the workbook.
- Cell Link: $H$4. This is the cell linked to the checkbox. You can also enter it manually or select the cell to get the reference.
Now your checkbox is linked to the cell. In the linked cells, TRUE appears for selected checkboxes and FALSE for cleared checkboxes.
Creating an Interactive To-Do-List in Excel
Below is the example of a To-Do-List that uses the checkboxes to mark the task complete.
A couple of things will happen in the example.
- As soon as you check-mark the list, the status will change to DONE from TO BE DONE.
- The value of the cell linked to that checkbox changes from FALSE to TRUE.
- It reflects the changes in the Task Completed and % Of Task Completed cell.
Follow these steps to make this interactive To-Do-List:
- List all the activities from G5:G9.
- Insert the checkboxes from H5:H9.
- Link the checkboxes to cell J5:J9. You will have to manually link each checkbox one by one.
- In the cell I5, enter the following formula: =IF(J5,” Done”,” To Be Done”) and drag for all the cells below.
- In the cell H11, enter the following formula: =COUNTA(G5:G9) to count the total number of tasks.
- In the cell H12, enter the following formula: =COUNTIF($J$5:$J$9, TRUE).
Link a Checkbox to a Cell
To record the status (checked or unchecked) of a checkbox, you must connect it to a specific cell. To accomplish this, follow these steps:
The Next Step
You have learned how to add a checkbox to an Excel spreadsheet in this post. With the help of the checkboxes, you have also developed an interactive To-Do List.
By enrolling in the Business Analytics with Excel course, which includes Power BI training, you may advance your career in analytics by acquiring potent new Excel abilities. This course in Business Analytics teaches the fundamentals of data analysis and statistics to facilitate data-driven decision making. This tutorial introduces you to Power BI and goes into the statistical ideas that will enable you to derive insights from available data and show them using dashboards designed for executives.
Have you any questions FOR US? Feel free to ask them in the article’s comments area; our specialists will respond as soon as possible!