Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove (form) check-boxes from multiple excel fields?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove (form) check-boxes from multiple excel fields?
You need to select them using the Drawing selection tool. First view the
Drawing tool bar (ViewToolbarsDrawing). 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! -- ERR229 "ATSANAC" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove (form) check-boxes from multiple excel fields?
Press F5, click special and select objects, hit delete
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "ATSANAC" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create drop down form fields in Excel? | Excel Discussion (Misc queries) | |||
How do you remove a check box (Control) in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
How do I remove multiple hyperlinks in the same cell (Excel)? | Charts and Charting in Excel | |||
Excel Drop Down box or check box data to Excel Database | Excel Discussion (Misc queries) | |||
How can I sort check boxes in excel? | Excel Worksheet Functions |