1. Highlight the range of data that you want make into a list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.).
Note You can also select the range of cells to be specified as a list by selecting the range of cells from the Create List dialog box.
2. On the Data menu, point to List, and then click Create List.
3. If the selected data has headers, select the My list has headers check box and click OK.
The selected range of data is highlighted by the list indicator, and the most common list related functionality is made available on the List toolbar.
Note If you don't see the List toolbar, on the View menu point to Toolbars, and then click List.
After the list has been created, it will be identified by a blue border. In addition, AutoFilter drop-downs will be automatically enabled for each column in the list and the insert row will be added as the last row or the list. If you choose to add a total row by clicking Toggle Total Row Button image on the List toolbar, a total row will be displayed under the insert row.
When you select a cell, row, or column outside of the list, the list becomes inactive. An inactive list is surrounded by a blue border and does not display the insert row or AutoFilter drop-downs.
Note The border will not be displayed if you clicked Hide Border of Inactive Lists on the List menu.
create dropdown list
1.Select the cell where you want the drop-down list.
2. On the Data menu, click Validation, and then click the Settings tab.
3. In the Allow box, click List.
4. If the list is in the same worksheet, enter a reference to your list in the Source box.
5.If the list is elsewhere, enter the name you defined for your list in the Source box.
6.Make sure the reference or name is preceded with an equal sign (=).
7. Make sure the In-cell drop-down check box is selected.
8. Specify whether the cell can be left blank: Select or clear the Ignore blank check box.
9. To display optional input instructions when the cell is clicked, click the Input Message tab, make sure the Show input message when cell is selected check box is selected, and then fill in the title and text for the message.
10.Specify how you want Microsoft Excel to respond when invalid data is entered.