Solved

# Making a columns of cells a dropdown

Posted on 2014-03-26
132 Views
How do I make a columns of cells dropdowns that select a values from another sheet in the workbook?
0
Question by:Matt Pinkston
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 19

Accepted Solution

helpfinder earned 500 total points
ID: 39957615
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

LVL 39

Expert Comment

ID: 39957623
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month7 days, 4 hours left to enroll