Forum Discussion
How can I find merged cells in a large spreadsheet?
The file has around 80,000 cells. When I tried a new sort, it said "To do this, all the merged cells need to be the same size". I use merged cells fairly often, but I can't remember where I did that...
Thanks, Sergei. However, I've read through that carefully and it does not help. I want to find the merged cells, I do not want to unmerge them (at least, not until I have found them).
In addition, Find works in my case. Ctrl-F -> Format -> Alignment -> Check "Merge Cells"
Ok -> Find All
I'm on