how to create pick list

Do you mean a "Pick From list"? If so, it creates itself as you enter data in a column of contiguous cells. In the next available cell (say A10 if data exists in A1:A9), right click on cell A10 and choose Pick From List, then make your selection based on unique data you have entered already. If this is not what you are asking about, please repost.

Tom Urtis

thanks for the reply. i guess i'm trying to create a pull down menu.

Somewhere is your workbook, type a list of options you want the user to choose from. Highlight the list and give it a name that makse sense to you, ie choose. Select the cell or range of cells you want the choice to appear, select Data Validation from the Data menu. In the Allow drop down box, select list, and in Source type the name you gave your range EXACTLY as it was named. A little arrow will appear whenever the user selects a cell that has data validation applied, and they can click on it and your list will appear. If you want to add choices, insert cells in your list, don't add them to the bottom. You can also give users messages so they know what data is expected if they input wrong data.
HTH
Richard