Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

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.

Re: how to create pick list

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


Re: how to create pick list

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.

Re: how to create pick list

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.