How To Find A Merged Cell In Excel

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

Under the Home tab, click Find and Replace

Step 2 – Click Find

Click Find

Step 3 – Click Options under the Find tab

Click Options under the Find tab

Step 4 – Click Format

Click Format

Step 5 – Under the Alignment tab, click Merge Cells, and press OK

Under the Alignment tab, click Merge Cells, and press OK

Step 6 – Click Find All

Click Find All