You can easily locate all of your merged cells in Excel on Windows by using the Find tool. Or, you can unmerge all of your cells in Excel on Mac.
Have you ever tried to sort data in Excel, only to receive an error about merged cells? It can be a pain to try and locate all of those merged cells manually. Luckily, there’s a simple way to find them.
Microsoft Excel on Windows offers a Find tool that offers extra options. This allows you to locate cells with specific formatting.
Note: Currently, Excel on Mac doesn’t have this robust search tool. These instructions currently only apply to Windows. On Mac, you’ll need to unmerge all of your cells (as discussed below).
Head to the sheet where you want to find the merged cells and go to the Home tab. Select the “Find & Select” drop-down arrow and pick “Find.”
Read Full Article Source