See all How-To Articles

How to Find Merged Cells in Excel

This tutorial demonstrates how to find merged cells in Excel.


find merged cells 5


Find Merged Cells

If you have an Excel file that contains a lot of merged cells, you can easily find them all at once with Find & Select. Say you have the following file with merged cells (A1, D3, A4, and C6).


merged cells initial data


To find all merged cells in a worksheet, follow these steps:

  1. In the Ribbon, go to Home > Find & Select > Find (or use the keyboard shortcut CTRL + F).


find merged cells 1


  1. In the Find and Replace window, choose Format.


find merged cells 2


  1. Go to the Alignment tab, check Merge cells, and click OK.


find merged cells 3


  1. Now, back in the Find and Replace window, click Find All.


find merged cells 4


The list of all merged cells appears at the bottom of the window.


find merged cells 5


As you can see, merged cells A1, D3, A4, and C6 are listed. Clicking on a row in the list selects the found cell.

See all How-To Articles