MrExcel Consulting
Your One Stop for Excel Tips & Solutions

how to create pick list


Posted by Cassandra on November 08, 2001 5:23 PM

I have been searching through the help files in Excel
trying to create a pick list, but cannot understand the instructions. That or i am not looking in the right place.

Posted by Tom Urtis on November 08, 2001 5:29 PM

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

Posted by cassandra on November 08, 2001 5:50 PM

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

Posted by Richard S on November 08, 2001 6:01 PM

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