Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Excel puts up this complaint when the range of cells you are trying to sort includes merged cells.

enter image description here

But if it's a large sheet how do you track down the merged cells?

share|improve this question
up vote 4 down vote accepted

Edit > Find > Format (specify merged cells) > Find All.

Or use a macro:

Option Explicit

Sub testme()
    Dim myCell As Range
    Dim resp As Long

    For Each myCell In ActiveSheet.UsedRange.Cells
        If myCell.MergeCells Then
            If myCell.Address = myCell.MergeArea(1).Address Then
                resp = MsgBox(prompt:="found: " _
                & myCell.MergeArea.Address & vbLf & _
                "Continue looking", Buttons:=vbYesNo)
                If resp = vbNo Then
                    Exit Sub
                End If
            End If
        End If
    Next myCell
End Sub
share|improve this answer
years and years of using Excel and never before noticed (or used) Find, Format. Thanks. – hawbsl May 4 '11 at 14:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.