How do you keep a list drop-down menu visible?

[phatfish]

I would like to keep the drop-down menu created when you make a list in
Excel 2003 visable, even when you dont have a cell active in the area
the list has been created. It seems the default behavior is to hide the
drop-down menu unless a cell in the list area is active.

I have another document here that somone else created (dont know who)
where the drop-down menu for filtering using a list is ALWAYS visable.
Its driving me nuts trying to find out how it was done.

If anyone knows i would be very grateful.

Thanks

 

[Dave Peterson]

It sounds like they used Data|Filter|autofilter.

I would like to keep the drop-down menu created when you make a list in
Excel 2003 visable, even when you dont have a cell active in the area
the list has been created. It seems the default behavior is to hide the
drop-down menu unless a cell in the list area is active.

I have another document here that somone else created (dont know who)
where the drop-down menu for filtering using a list is ALWAYS visable.
Its driving me nuts trying to find out how it was done.

If anyone knows i would be very grateful.

Thanks

 

[phatfish]

Ah, i see now you are correct. Just checking "Autofilter" applies the
filter to the highlighted columns, with the same behavior i was after.

Thanks very much.