How do I remove (form) check-boxes from multiple excel fields?

[Guest]

I've introduced tick-boxes from the forms tool-bar into multiple cells in an
excel spredsheet. These work fine, i.e. clicking the box ticks it or clears
the tick; however, when I tried to remove these tick-boxes, none of the
standard excel methods to clear the cells seem to work. Clear-contents does
not remove the tick-box from the cell, nor does hitting the delete key on a
selected cell. Deleting an entire column of cells with tick-boxes just shifts
the tick-boxes to adjacent column that replaced the deleted one. I could
simply copy all but the tick-boxed cells into a new workbook, but there must
be an easier way.

 

[Guest]

You need to select them using the Drawing selection tool. First view the
Drawing tool bar (View>Toolbars>Drawing). The toolbar appears at the bottom
of the screen. Click the Select Objects tool (it's a white arrow). Once you
turned on that tool, you can select and delete your check boxes.

Hope it helps!

 

[Peo Sjoblom]

Press F5, click special and select objects, hit delete

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com