Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |