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.