How to Find Merged Cells in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on February 23, 2023

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.

AI Formula Generator

Try for Free

See all How-To Articles