Automatically Add Checkboxes to New Rows in an Excel Table
Question details
The user wants checkboxes to be added and linked when new rows are added to an Excel table.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel table grows as new records are entered, and each record needs a checkbox.
- Observed behavior
- Each new table row should have a checkbox whose checked state can be used in formulas or other processing.
Check whether your Excel version has Insert > Checkbox. For a VBA solution, identify the table name under Table Design and decide which columns will hold the control and its linked value.
Use Excel cell checkboxes in the table
Use this method if your Excel version supports cell checkboxes and table formatting extends to new rows.
Select the existing data cells in the table's checkbox column, then choose Insert > Checkbox.
Type directly below the table or press Tab in its last cell to add a row. Check whether the new checkbox-column cell displays a checkbox.
Reference the checkbox cell in a formula or another cell. Its value is TRUE when checked and FALSE when unchecked.
If a new row does not inherit the checkbox, select its checkbox-column cell and choose Insert > Checkbox, or copy an existing checkbox cell into it.

Add a table row and linked Form Control checkbox with VBA
Use a macro to add both the row and its linked legacy checkbox in one action.
Work with Excel tables in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move between office suites. It does not fix Excel-specific checkbox or VBA behavior, so test those features before migrating a workbook.

Frequently Asked Questions
Why is Insert > Checkbox missing in Excel?
Cell checkboxes are available only in supported versions of Excel. If the command is missing, use Developer > Insert to explore legacy Form Control checkboxes or update Excel if an update is available.
Do cell checkboxes need a separate linked cell?
No. A cell checkbox stores TRUE or FALSE in its own cell. Reference that cell directly in a formula or another cell.
Will the VBA macro add a checkbox when I type a new row?
No. The provided macro adds the row and checkbox when you run AddRowWithCheckbox from Developer > Macros. Rows added by typing are not handled by that macro.
What happens to Form Control checkboxes when I sort or delete rows?
Form Controls float over cells, so their position and linked values should be tested after sorting or deleting rows. The macro uses Move and Size with Cells, but controls may still need adjustment or cleanup.




