Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
ERR229
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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
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 04: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 07: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 06:43 PM.

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

About Us

"It's about Microsoft Excel"