Smart Check Box
Excel Tips and Tricks

Excel Tip: Checkbox in Excel Table

Check box control in Form Controls is very useful in Microsoft Excel. Here we have created a table in each row one check box is available. We have used conditional formatting to highlight the checked row. Calculation of Total is changed according to checked rows.

 

Below is the table with Check boxes

Table with Check box
Table with Check boxes

 

Click here to download this Excel file

 

Watch the step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com