How To Find A Merged Cell In Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-15.jpg)
Spreadsheets sometimes get really massive that there cells that are merged which would be difficult to find. But it is possible to find it.
Step 1 – Under the Home tab, click Find and Replace
![](https://spreadcheaters.com/wp-content/uploads/Step-1-14.jpg)
Under the Home tab, click Find and Replace
Step 2 – Click Find
![](https://spreadcheaters.com/wp-content/uploads/Step-2-14.jpg)
Click Find
Step 3 – Click Options under the Find tab
![](https://spreadcheaters.com/wp-content/uploads/Step-3-12.jpg)
Click Options under the Find tab
Step 4 – Click Format
![](https://spreadcheaters.com/wp-content/uploads/Step-4-3.jpg)
Click Format
Step 5 – Under the Alignment tab, click Merge Cells, and press OK
![](https://spreadcheaters.com/wp-content/uploads/Step-5-2.jpg)
Under the Alignment tab, click Merge Cells, and press OK
Step 6 – Click Find All
![](https://spreadcheaters.com/wp-content/uploads/Step-6-2.jpg)
Click Find All