General discussion

Locked

Pick List

By layland ·
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!

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Pick List

by emcs In reply to Pick List

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

Thanks.

dennie

Collapse -

Pick List

by layland In reply to Pick List

Thanks for your time. I found my solution.

Collapse -

Pick List

by SanKulPune In reply to Pick List

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.

Collapse -

Pick List

by layland In reply to Pick List

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!

Collapse -

Pick List

by layland In reply to Pick List

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums