I have a lot of data in a Google spreadsheet that depends on charts I spent ages trying to make look pretty.

There is a stupid block of merged cells that won't unmerge, and when I try to cut-and-paste the main block of data, it doesn't paste where it should (presumably because of the stupid merged cells).

So I can't unmerge, and I can't cut-and-paste, and I definitely can't be bothered to spend all that time again to make a new spreadsheet.

What do I do? Why can't I unmerge? I can't even highlight it red in the snapshot below. When I do, it highlights a completely different row (the orangey one starting with the word #motifs).

enter image description here

  • Good idea, the data's quite confidential.. but i'll see if i can replicate what i've done to a smaller scale and send the link May 13, 2014 at 11:22
  • 1
    @pnuts your hunch is very true... May 13, 2014 at 14:54
  • 1
    I'll try a lil later, sorry, so many things I need to do today! May 13, 2014 at 16:10


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.