Do all the cell links for the check boxes need to be done manually or can excel do the links automatically.

Just like when you copy and paste a cell with a formula to another cell, it copies the formula but updates the cells its referencing to.

I want to do the same thing with the check box. but when I paste the check box, it keeps the original reference cell link. I already made sure what the cell link is not absolute.

Or am I going about this wrong.

Thanks for your help.