You can use programming to hide some of the dropdown 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
c.AutoFilter Field:=c.Column, _
Visibledropdown:=True
Case Else
c.AutoFilter Field:=c.Column, _
Visibledropdown:=False
End Select
Next
Application.ScreenUpdating = True
End Sub
'==============================
rudawg wrote:
You all might begin to wish I never found this forum. But the help truly is
appreciated.
I have created a list which naturally turned on the autofilter feature. How
can I turn off the autofilter feature for all but two of the columns?
Thanks
Rudy
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html