Forum Discussion
Checkboxes
I want to put a checkbox in a cell (let's say B2) and then grab the lower right hand corner of B2 to drag it down by let's say 200 cells, therefore putting that checkbox in cell B3, B4. B5 etc etc).
Hope this is clearer?
That simply won't work. Filling or dragging only replicates the cell, not objects floating above it such as a check box.
Apart from that, managing hundreds of check boxes would be a nightmare. I'd keep it simple and let users enter an "x" in the cells themselves, or something similar.
HansVogelaar Hi Hans,
Oh, I find this odd? I’ve seen various videos online of people doing exactly that, putting a checkbox inside a cell, then dragging that cell down for it to replicate. I tried it on excel at work and it worked, now at home I can’t get it to!
I second HansVogelaar 's recommendation.
I've come across many workbooks using hundreds of objects (it really doesn't matter if they're check boxes, small pictures, etc.) and the common thread is the navigation in these workbooks is very slow. The issue is Excel will struggle to render the objects on screen (Even if the objects are very small).
