22 Aug 2014

Quickly find merged cells in Excel

You are in a hurry and want to prepare some data in a minute, but unable to sort, filter or use pivot table. You are left wondering what and where went wrong, until you see the error.

Imagine you have a thousands of rows, it would be a huge tasks to find out where the meged cell is.
Here is a simple tip to find it immediately.

1) Open Find option by pressing Ctrl+F

2) Click Format. You wiill see Formatting options.
3)  Go to Alignment tab and select "Merge Cells"

4) Click Ok to close the option. Go to the Find option and click "Find all"

5) You will see all the merged cells listed.


comments powered by Disqus