Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-2018, 08:35 AM
Black Kat Black Kat is offline How to remove check boxes in imported data? Windows 7 64bit How to remove check boxes in imported data? Office 2010 64bit
Novice
How to remove check boxes in imported data?
 
Join Date: May 2014
Posts: 5
Black Kat is on a distinguished road
Default How to remove check boxes in imported data?

I'm webmaster for my local church & am trying to create reports for them on how popular some areas are. The only way to do this is via a copy/paste more usually into Word but as some of the source material is in tabular form it's more useful to start in Excel first.


So my primary problem is with check boxes. For some reason once they're imported into Excel they're hiding in plain sight - I can see them, stick a tick in them, but to every other intent or purpose, they;re invisible. I can't highlight them, delete them or find how or where the "coding" is that's preventing me from getting rid of them.



I can do what I want in Word, but everything else takes far longer to sort out as the tables paste in so messily. Hence my preference to clean up the data in Excel.
Any ideas? I'm an Excel newbie but competent working with software
Attached Images
File Type: jpg bmc excel.JPG (13.6 KB, 13 views)
Reply With Quote
  #2  
Old 02-12-2018, 09:17 AM
xor xor is offline How to remove check boxes in imported data? Windows 10 How to remove check boxes in imported data? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

I am not sure if the following will help, but you can give it a try.

Press F5, then Special, put a dot in Objects and press OK. If the check boxes are selected then press Delete.
Reply With Quote
  #3  
Old 02-12-2018, 10:42 AM
Black Kat Black Kat is offline How to remove check boxes in imported data? Windows 7 64bit How to remove check boxes in imported data? Office 2010 64bit
Novice
How to remove check boxes in imported data?
 
Join Date: May 2014
Posts: 5
Black Kat is on a distinguished road
Thumbs up

AWESOME!! It worked perfectly & you've taught me a new element in Excel which may be of use in future problems. Thanks SO much not just for the answer but your speedy reply too. Much appreciated!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to remove an imported Object background? Rez PowerPoint 2 05-03-2017 07:53 AM
How to merge text boxes in a large imported document boatfly Word 3 04-20-2016 06:15 AM
How to remove check boxes in imported data? Check boxes that insert data from Excel spc94 Word VBA 1 06-22-2015 01:46 PM
Word2010 check boxes and plain text content control boxes in same table fcsungard Word 5 06-01-2012 01:16 AM
Problem with Developer Form -- Check Boxes and Text Boxes PCC Word 1 05-16-2009 05:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft