Religion & Spirituality1 min ago
Excel and tick boxes
1 Answers
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...)
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...)
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.