Forum Discussion

Copper Contributor

Mar 17, 2022

Add Checkbox when New Row is Made

Hi All, I'm trying to find a way to automatically add checkboxes to particular cells when a new row of a table is made (e.g. pressing tab at the end column of a table to make a new row). As f...

excel

Formulas and Functions

Macros and VBA

Natalia

Copper Contributor

Nov 08, 2024

Hi everyone. I've just found a way to do it. Just convert your excel rows to a table (Select rows, then click Insert → Table). When you add a new row to a table, all check boxes and predefined Data Validation rules will be copied to a new line. It works pretty good for me.

TigerTedd Toby-Jon Azaxa