Forum Discussion

Azaxa's avatar
Azaxa
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 far as I'm aware, checkboxes from the Developer tab can be somewhat automatically made by:

  1. Drag it to a cell
  2. Drag the autofill across to another cell (the bottom right square when clicking on a cell)
  3. New checkbox is duplicated onto the new cell

However, when making a new row, this does not duplicate without using the above method.

 

Is there a way to do this? Preferably without the need for a click-button macro

 

Thank you 

  • Natalia's avatar
    Natalia
    Copper Contributor

    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 

  • TigerTedd's avatar
    TigerTedd
    Copper Contributor

    Azaxa I was just looking for this feature as well, and wondered if there was any progress with the new check boxes.

     

    I've tried it with the new check boxes. It doesn't work, so I guess the answer is no. Which is a shame. Back to yes / no drop downs for me.

Resources