How do I get a drop down list arrow to remain visible at the top of a column?
I've seen it before but am not able to figure this one out. I'm using Excel
2003. Thank you!

It sounds like you need to click Data in the Excel menu and then Filter from
the drop down menu and AutoFilter from the cascade menu.
--
Kevin Backmann


"kim" wrote:

How do I get a drop down list arrow to remain visible at the top of a column?
I've seen it before but am not able to figure this one out. I'm using Excel
2003. Thank you!

Hi,

Do one of the following:

Procedure 1:

1. Select the column header, and the cell values in the cloumn.

Important: Do not select the whole cloumn.

2. Right-click and select "Create List" from the menu. The Create List
dialog box appears.
3. Verify whether the range you have selected is correct in the "Where is
the dat for the list?
4. Assuming that you have already have column header, retain the defalut
setting for the My list has headers check book. If you want Excel to include
a header, then select the My list has headers check box.
5. Click Ok to to view your list. You can notice a "*" at the end of the
list. This will allow you add more values in the cells below, which can
filtered later on those cells.

Procedure 2:

1. Select the column header, and the cell values in the cloumn.

Important: Do not select the whole cloumn.

2. On the Data menu, point to List and then click "Create List". The Create
List dialog box appears.
3. Verify whether the range you have selected is correct in the "Where is
the dat for the list?
4. Assuming that you have already have column header, retain the defalut
setting for the My list has headers check book. If you want Excel to include
a header, then select the My list has headers check box.
5. Click Ok to to view your list. You can notice a "*" at the end of the
list. This will allow you add more values in the cells below, which can
filtered later on those cells.

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++

To convert List to Range,

Do one of the following:

On the List tool bar, select Conver to Range"
-or-
On the Data menu, point to List, and then click Convert to Range

Challa Prabhu

"kim" wrote:

How do I get a drop down list arrow to remain visible at the top of a column?
I've seen it before but am not able to figure this one out. I'm using Excel
2003. Thank you!