Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros.

Insert a Check Box Select the cell to which you want to add the check box and click "Insert" from the Developer tab. You'll see check box icons under both Form Controls and ActiveX Controls.

Adding a Check Box When you switch to the Developer tab in the Microsoft Excel Ribbon and locate the Controls group, you can click on the "Insert" item to open its drop-down menu.

Tgood37 asked the Answer Line forum how to add checkboxes to Excel spreadsheets, and make sure that checking a box will have an effect.

Episode 27How to add a checkbox in Excel, a small but powerful data tool for spreadsheets Mar 3, 20165 mins Microsoft Excel Microsoft Office Office Suites SUBSCRIBE TO OUR NEWSLETTER ...