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...
Perhaps this Excel -Sort cannot find merged cells - Microsoft Q&A could help
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
LindsayGraham​ , depends on your subscription you could have Inquire. It's not activated by default, check it in File->Options->Add-ins
Tab shall appear on ribbon, here use Workbook Analysis
It will show you addresses of merged cells among other information
Double click on address, it forwards you to the cell.
