• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

Making a columns of cells a dropdown

How do I make a columns of cells dropdowns that select a values from another sheet in the workbook?
0
Matt Pinkston
Asked:
Matt Pinkston
1 Solution
 
helpfinderCommented:
Use Data Validation feature in Excel
Select cell you want drop down apply to. Go to Data>Data validation>choose List>highlight values in another sheet you want to be a drop down items and press OK. Then copy down this drop down cell to as many cells as you wish
0
 
nutschCommented:
define the range of values as a defined range (Ctrl+F3, then New, etc.)
Go to your dropdown cell, Data \ Validation \ Allow List,
=YourRangeName as the Source.

Thomas
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now