Check box in Excel

what is a checkbox in Excel?

Checkbox in Excel is tool that can be used to select or deselect an option in workbook. You can use a checkbox in Excel to create dashboards, checklists, and dynamic charts.

How to inset a checkbox in Excel?

Insert checkbox in Excel is a very easy and simple process. To insert a checkbox in excel worksheet, please follow these steps.

1. Open the Developer tab, in the Controls group and click Insert.

2. Choose Check Box Form Controls section.

3. Draw checkbox on worksheet. You can delete or rename the checkbox by clicking on text.

How to link checkbox in Excel?

To link a checkbox, follow these steps.

1. Press Right click on checkbox and then click format control.

2. In control tab, make sure by default your checkbox is marked uncheck and then give reference to a cell where you want to link the checkbox because it will show the status as True and false.

3. Test the Checkbox, when you un check the box it will display "False" and if you check the box "True" will display a below. Our checkbox is working fine.

Create a Checklist

To create a checklist, follow these steps and watch video tutorial till end.

Draw a checkbox in any cell.
Click on the lower right corner of first cell and drag it down to cell where your products are. (For Example D2:D12 , where D2 is first and D12 is last), you can mannually set and align as describe in video tutorial.
Right click on first checkbox and then click Format Control.
Give reference cell link to checkbox.
Repeat same process (format control & reference cell link) for all checkboxes.
insert ROWS formula to count total products.
Use COUNTIF formula to count the number of items packed.
IF formula will be used to evaluate if you're good to go.
Click all check boxes, and it will show you that you are good to go.
Download sample file from below Link

Download Sample File

Also Read This : Status bar in excel

Pages

Friday, April 16, 2021