#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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!
|
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 |
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 |