You could use a macro to hide some of the arrows. For example:
'==========================
Sub HideSomeArrows()
'hide some autofilter arrows
Dim c As Range
Dim i As Integer
i = Cells(1, 1).End(xlToRight).Column
Application.ScreenUpdating = False
For Each c In Range(Cells(1, 1), Cells(1, i))
Select Case c.Column
Case 2, 3, 5, 6
c.AutoFilter Field:=c.Column, _
Visibledropdown:=False
Case Else
c.AutoFilter Field:=c.Column, _
Visibledropdown:=True
End Select
Next
Application.ScreenUpdating = True
End Sub
'=============================
Copy the code to a regular module, as described he
http://www.contextures.com/xlvba01.html
To run the macro, activate the sheet with the AutoFilter
Then choose ToolsMacroMacros
Select the HideSomeArrows macro, and click the Run button
celestemberner wrote:
I have a list of clients, phone numbers, types of business and dollar
amounts. I only want to use the auto filter for the columns that have client
name and types of business. It would do no good to filter by phones numbers,
etc.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html