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
