Forum Discussion
Check boxes
This may not be the best solution but one thing you could try is to select all the check box controls below the row you inserted and drag them down a row. If your sheet auto inserted a check box control with your row then you would have an extra check box below your last row that you can simply delete, otherwise your last check box should line up with your last row.
To select the check box controls instead of cells go to the home tab on your ribbon and select the icon all the way to the right "Find & Select". From the drop down choose "Select Objects". Now you can drag a box around your check boxes and move them. When your done you would need to repeat this step this time deselecting "Select Objects". Now you can select individual cells again.
I will give this a try. Thank you very much!