Donate SIGN UP

Excel and tick boxes

Avatar Image
funkylad20 | 14:12 Fri 09th Oct 2009 | Technology
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...)
Gravatar

Answers

Only 1 answerrss feed

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.
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...

Only 1 answerrss feed

Do you know the answer?

Excel and tick boxes

Answer Question >>