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
