I am creating a large data entry excel spreadsheet and I want to be able to
insert, probably 100+ check boxes, my problem is that I dont want to have to
associate every single checkbox with every single cell. is there a way that I
can just click and drag (like fomulas do) and have the cells be populated by
checkboxes.

I do not want to have to right click each checkbox -- properties --
control, and then link the value to a cell.

Please help!