How do I fill down checkboxes linked to cells and have the cell references transpose?

by |Published November 19, 2019

I added a checkbox to my excel sheet, and I go to properties and it lets me link it to a cell. I want to do a ‘fill down’ to get a column of checkboxes, but so all the checkboxes are linked to their own cell.

However when I do a fill, all cells end up linked to the first cell. Checking one checkbox checks them all.

I am not sure how to solve this. Any ideas?