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?
Maybe this guide will help you where you can just drag down the cell with the check box with the mouse... it's probably the way you see in many videos.
How to insert multiple checkboxes
In Excel, Fill Handle is a function to do many things. It can also fill the checkboxes. First, you need to insert a check box.
Proceed as follows:
1. Click Developer on the menu bar, click Insert, and check the box under Form Control.
Note to 1:
The Developer tab isn't displayed by default, but you can add it to the ribbon.
On the File tab, go to Options -> Customize Ribbon.
Under Customize the Ribbon and under Main Tabs, select the Developer check box.
2. Click on the check box and you will see a plus sign pointer.
Click where you want to add the check box.
3. Select the check box (Form Control), move it to a cell and clear the check box name.
4. Then select the cell where the check box is located. Then use your mouse to drag the cell down over the range of cells you want to fill.
Thus you have check boxes in the desired cells.
*Attached is a file where you can simply drag down the cells of the check box with the mouse.
Hope that helped...if not, please just ignore.
I know I don't know anything (Socrates)