How to Find Merged Cells in Excel

Merged cells are sometimes great in displaying some contents, however, it can be a trouble when you copy or sort the data that contains merged cells. You need to find these merged cells before you sort or properly copy and paste. Please follow the steps below to find the merged cells in a worksheet.

Step 1: Click anywhere in the worksheet;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Find&Select", and select "Find" from the list;

You can also use the shortcut "Ctrl+F" to display the "Find and Replace" window.

Step 3: In the "Find and Replace" window, click "Format";

Step 4: In the "Find Format" window, under the "Alignment" tab, select "Merge cells" and click "OK" at the bottom;

Step 5: This returns back to the "Find and Replace" window, click "Find All" and you will see all the locations with merge cells appear in the box below;

Step 6: Click any row and the cursor will move to the merged cell;

Step 7: Once you finish your work, it is better to repeat the steps to clear the selections by clicking the "Clear" button in the "Find Format" window.

Leave a Reply