I have seven cells and want to insert a check box into each individual cell. I have done this using 'form' BUT when I try to copy it down to the other 1,000 lines below, they go all adrift, esepcially when a line lower down is slightly wider.
Is there any way to have something in the cell (other than a list drop down) which can be 'checked' and 'un-checked' with the mouse to show if it is relevant or not ?
(Scenario - Documents 1 - 7, if they are required for each candidate, the relevant cell is ticked...sometimes 1 document is required, sometimes all 7...)
I think you have to type your chosen symbol in the tick box and press Enter, rather than simply use the mouse to click the box. However, if you check out Google - (search for 'excel inserting tick boxes'), you'll find there's simply loads of links...