Discussion Locked

Pick List

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do you make a pick list in excel? Example:
A1 cell I need a drop down list for that one cell.

Thanks for your time!

5 replies

by emcs

Show me what you want to choose from, and what happens when you choose it.

Thanks.

dennie

by sankulpune

Hello,

1) In a convenient location in the worksheet, create the list you want to pick the values from.

2) Select the cells in which you want to pick up values from this list.

3) Use the following menu sequence:

Data > Validation > select 'List' in the "Allow" drop down list > in the 'Source' text box type the range in which the list values are stored. >
Check the checkbox 'In-cell dropdown'

4) Make any other settings as per your requirement in the 'Data Validation' dialog box.

5) Click OK.

Now whenever you select the cell with this data validation rule, you will see a drop-down arrow in the cell. Using this arrow you can see the drop-down list from which to select values.

Your feedback will be highly appreciated.

Please do contact me if you need any additional information that will help you to evaluate this solution.

With best regards,

SanganakSakha.
Simple And Effective Solutions To Small Problems, No QuickFixes.

by layland

Thanks for your time! I found the Validation. How do make cells populate data when the cell in the drop list is populated that relates to that value?
Example: Say cell A1 was created as the drop list with 10 different values. When one of those values are selected the associated values will populate in cells
A2, A3, A4 etc..? Can that be done? Thanks again for your time!

This discussion is closed to new replies.