Fill column a with checkboxes

[Maveric169]

I am trying to fill column A with check boxes for 1,000 rows that will use conditional formating to change the background color of the row when checked. I got everything to work in row 2 (starting row) but i need to duplicate this for 1,000 rows. Please tell me there is an easier way to do this without clicking and pasting and changing 1000 cells one at a time.

[Maveric169]

Did I stump everyone with this one? There has to be a way to copy an object to multiple rows.

[Zizi64]

The Data - Validity function is not appropriate for you? You can use the 0 and 1 values or the ☑ and ☐ unicode characters in the validity list.

And you can copy the function in simple way into other cells.

[Lupp]

There has to be a way to copy an object to multiple rows.

How come?

A CheckBox has properties and a functionality. Much of that will need adaption for the copy depending on the specific intentions of the user. If you considered this well, and know what actually can remain unchanged, and what needs adaption in what way, you can write custom code to perform the action.

Always keep in mind that any form control is content of a shape. The shape in turn may be anchored to a cell, but never is content of a cell. It is a member of the DrawPage of the sheet.