Forum Discussion
How can I find merged cells in a large spreadsheet?
You can find merged cells in a large spreadsheet by using the Find feature in Excel. Just press Ctrl + F, click Options, then go to Format → Alignment → Merge cells and click Find All. This will show all merged cells in the sheet. Another simple way is to select the whole sheet and visually check for cells that don’t align properly, because merged cells usually stand out when you select or sort data.
Thanks, mohdadeeb. But what you've described is exactly what I did (ie, the Help instructions for 'Find merged cells') but, at the 'Find All' step, I got the error message shown in my original post. The spreadsheet is too big for me to visually check for merged cells and, as explained in my original post, I can't sort the file. Any other suggestions?
