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