Excel怎样在工作表中查找与指定区域（按住鼠标拖动圈起来）一模一样的片段，（指定区域都是一列多行）？

可以用vba
按住ALT,依次按F11,I,M
粘贴代码后在工作表中

选中要查找的区域，按ALT+F8执行该宏即可

Sub 区域查找()
With Selection
s = .Cells.Count
For i = 1 To s
t1 = t1 & "###" & .Cells(i, 1)
Next
For Each c In ActiveSheet.UsedRange.Cells
If c.Address <> .Cells(1, 1).Address Then
For i = 0 To s - 1
t2 = t2 & "###" & c.Offset(i, 0)
Next
If t1 = t2 Then
c.Resize(s, 1).Select
If MsgBox("找到一组相同值，是否继续？", vbYesNo) = vbNo Then Exit For
End If
t2 = ""
End If
Next
End With
End Sub

好像只有通过vb脚本来实现,就是通过程序进行比对