My spreadsheet (just my home accounts) uses dozens of checkboxes. If a bill is paid (tick the box) then take the amount from the amount still to be paid out and show corrected balances. Easy.
But, if I resize the sheet for any reason the alignment of the checkbox to the cell it’s linked to sometimes goes off. It just leaves an untidy sheet with boxes drifting away. How can I force a checkbox to fill the cell that it is linked to? Is there a way to do it for lots of boxes in one formula?