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:

My Name is PK. I am founder of I am a Microsoft Certified Professional. I have more than 12 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.