However, there are a number of ways you can do this.
One way is to use the ‘Developer Tab’ to insert the checkboxes one by one. The second way is to insert one checkbox and then ‘drag and fill’ into the other cells, and thirdly, you can just ‘copy and paste’ into other cells.
Now, let’s look at these ways in more detail.
#Option 1: Using The Developer Tab
Go to Developer Tab -> Insert -> Form Control -> Select Check box icon.
Then click on any part of the worksheet and it will insert the check box. You can then move the checkbox to any preferred cell location in the worksheet.
Now, for you to insert multiple checkboxes, you will need to repeat this process over again.
But it should be noted that:
- The checkboxes are NOT automatically linked to any cell. You will need to link them manually.
- The check boxes appear with captioned names such as Check Box 1, Check Box 2, etc. You can right-click the box to edit the text.
#Option 2: Drag and Fill the Cells
Once you have inserted the first checkbox into a cell using option 1, click on the active cell to drag and fill it down to the other cells. It will duplicate copies of the check box into the cells like this:
Also, it should be noted that:
- The caption names of the checkboxes are the same, so you will have to edit the text to change the names.
- If the first checkbox has been linked to a cell already, all the other checkboxes will be linked to that same cell. So you will need to change the links of all the other checkboxes manually one by one.
#Option 3: Copy and Paste
Press Ctrl + D to allow you select the existing checkbox and then you can copy and paste it into the other cells.
Furthermore, it should be noted that:
- The copied checkboxes will be linked to the same cell and so you will need to change the cell link for each of the individual checkbox manually.
- Also, the caption names will be the same. Therefore, you can edit the text to change the caption names.