How to Find Merged Cells in Microsoft Excel
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.
Find Merged Cells in Excel on Windows
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).
RELATED: How to Find and Replace Text and Numbers in Excel
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