怎么可以在excel表中的一列里进行筛选？

Question

表里有很多列，各是不同的内容，怎么能在其中一列里进行筛选啊，只要那一列可以筛选哦

Answer 1

选定那一列，然后点击菜单栏的“数据/筛选/自动筛选”

Answer 2

选中整个工作表 执行 数据-筛选-自动筛选 然后点击你要筛选的列的小三角进行筛选

Answer 3

Function FilterCriteria(Rng As Range) As String
Application.Volatile
Dim Filter As String
Filter = ""
On Error GoTo Finish
With Rng.Parent.AutoFilter
If Intersect(Rng, .Range) Is Nothing Then GoTo Finish
With .Filters(Rng.Column - .Range.Column + 1)
If Not .On Then GoTo Finish
Filter = .Criteria1
Select Case .Operator
Case xlAnd
Filter = Filter & " 和 " & .Criteria2
Case xlOr
Filter = Filter & " 或 " & .Criteria2
End Select
End With
End With
Finish:
FilterCriteria = Mid(Filter, 2)
End Function

粘贴到模块中。

在d1单元格中输入公式：

=FilterCriteria(A1)