LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ATSANAC
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create drop down form fields in Excel? Micki Excel Discussion (Misc queries) 4 January 3rd 08 03:41 PM
How do you remove a check box (Control) in an Excel spreadsheet? zjan Excel Discussion (Misc queries) 2 April 17th 06 10:41 PM
How do I remove multiple hyperlinks in the same cell (Excel)? Hyper Charts and Charting in Excel 0 January 16th 06 06:24 PM
Excel Drop Down box or check box data to Excel Database TotallyConfused Excel Discussion (Misc queries) 3 October 26th 05 05:36 PM
How can I sort check boxes in excel? AT Excel Worksheet Functions 0 September 26th 05 07:15 PM


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"