Hi Jithu,

I just had a little play, and this will work but could get
a bit tedious in a large sheet or if you are looking for
a lot of merged cells.

For what it's worth
Select A1 and then Ctrl+Shift+Down Arrow
If only column A is selected then there are no merged cells in A
Tap the up arrow, then the right arrow, then Ctrl+Shift+Down Arrow
If only column B is selected then there are no merged cells in B
Keep going until more than one column is highlighted, this will signify
a merged cell in that column.
Tap the up arrow, then hold down Shift and keep tapping the down
arrow, the selection will stay in one column until you reach the merged
cell.

Like I said a bit tedious but not so bad if you are just searching
for one rogue cell.

HTH
Martin


"Jithu" wrote in message
...
How to find a merged cell in a work sheet full of data?