DashboardNovice
Member
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.
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.