Forum Discussion
Andrew_Hinson
Dec 10, 2022Brass Contributor
Checkboxes
Hi all, I have inserted a checkbox into a cell and am trying to drag it down a few hundred cells using the autofill function. However, when I drag it down the checkbox it will not autofill into t...
Andrew_Hinson
Dec 10, 2022Brass Contributor
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!
Patrick2788
Dec 10, 2022Silver Contributor
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).