Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I have a sheet with headings across the top and data below. I want to filter the rows shown based on the values for one column. That is easy, I hit the filter button and the little drop down list icon appears next to every header and I just add filters as and when I want.
Unfortunately I need to display lots of columns where the header is a date in the format 14/01, 15/01, 16/01 etc. When I hit the filter button the drop down arrow obscures most of the heading so I cannot tell what date it is.
Any way of not displaying the drop down arrows except on the column I am filtering?
You could align your cells to the left instead?
Just do a filter, not an autofilter
Not that it answers your question, but could you start the filtering a few blank rows above or below the dates in order to leave them visible?
Markie - has come up with he solution I am using.
clubber - that is what I was trying to do but Excel 2010 has 'improved' to the point that I can't work out how to do it.
You could go for a bit of this:
Sub HideSpecifiedArrows()
'hides arrows in specified columns
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 1, 3, 4
c.AutoFilter Field:=c.Column, _
Visibledropdown:=False
Case Else
c.AutoFilter Field:=c.Column, _
Visibledropdown:=True
End Select
Next
Application.ScreenUpdating = True
End Sub
But that might over complicate things??