Find Merged Cells Greyed Out

[Ampharos]

Hi there,

I'm trying to clean some data I received from another department, and they were unfortunately big believers in using merged cells.

In order to find and fix them, I typically used Find =>Options=>Format=>Alignment, and from there check the merge cells box to find them.

However, on this file, that option is greyed out and cannot be selected (pic below)

How can I fix this/alternatively find all the merged cells?

 

[konew1]

I think there is some level of protection on the sheet,

 

[Ampharos]

I think there is some level of protection on the sheet,

Hah, that was totally it! I completely forgot that the copy I had was still "shared". Switched it off and problem solved. Thanks!