Data Filter drop down
 

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

Data Filter drop down
 

Hi Ken,

Select the third row of headers and then apply the filter.

--
Regards,

OssieMac


"Ken" wrote:

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

Data Filter drop down
 

Hi Ken

Add a empty row between row two and three
and change the height of that row so you almost not see it

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ken" wrote in message ...
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

Data Filter drop down
 

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