• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Single cell appears as merged?

I have a file that is a data dump. I can't upload it because it contains confidential information.

I can't apply a background fill on some cells. I noticed that those cells show as merged because the Merged & Center button is depressed. When I click on one of these cells, there is no indication that the cell was merged over more than one column or more than one row. It appears to be a single cell that shows up as having been merged which doesn't make sense.

When I click the Merge & Center button to unmerge it, the cell value disappears however the value still remains in the formula bar.

The sheet is not protected. There is no conditional formatting applied either.

What I happening here?

I want to apply a background fill.
 
Top