A check mark box in an Excel spreadsheet is handy for ticking off items, but it can go much further. Excel check boxes can trigger calculations and provide visual indicators.

Now we are going to insert the check boxes. Select a cell. On the Developer tab, click the Insert button in the Controls group, then click the Check Box from the Form Controls group in the 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.

A check box in Excel can use either Excel's form controls or ActiveX controls for formatting. Form controls offer simple formatting, as well as the ability to add a check box to a chart sheet or ...