Data Filter drop down

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Hi again Group!
Is there any way on this earth to change the row where the data
filter drop down arrows show? I'm using Excel 2007 and of course the
first row is an assumed header row, and the drop down arrows appear at
the bottom of the row. I have a sheet where I used the first 3 rows to
make a header and if there's any way possible, I need the arrows to
appear on the 3rd row. Does anyone know of a way, possibly with a
macro??? Thanks for your help in advance.
Ken
 
Hi Ken

Add a empty row between row two and three
and change the height of that row so you almost not see it
 
Thanks guys for the advice! With the suggestion by OssieMac, I created
this macro and placed a button on the header and it works very well:

Sub FILTERING()
With Application
.ScreenUpdating = False
.EnableEvents = False
End With
Range("A3:X3").Select
Selection.AutoFilter
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
Range("A4").Select
End Sub

Then I just click the button again to remove the filtering.
Sorry about taking so long to get back to the group. Thanks again
Ossie and Ron.
Ken
 
Back
Top