trouble with drop down list

G

gmwshop

I'm trying to make a simple spreadsheet with a few cells that have
drop down lists that limit entries to four choices. I have tried to
follow the directions perfectly, but I can't get it to work. Sheet 1
is the spreadsheet. Sheet 2 contains the list. I select the
consecutive entries on the list and type "name" into the name box next
to the function field. I go back to sheet 1, select the cell, then
data>validation>list>source>then type "name". The list does not come
up in the field, only the word "name". I'm sure there's a step wrong
in there somehow, but I'm stumped. Can someone help? I can email the
spreadsheet if it would help. Thanks.
 
D

Don Guillett

Try with the = sign and without the " " and I suggest you use MYname instead

=name
 
S

Shane Devenshire

Hi,

And if still don't get it to work, then check to make sure name is really
been defined. The problem with the Name Box is you must rememeber to press
Enter when enter a name, otherwise the name vanishes.

Cheers,
Shane Devenshire
 
T

T. Valko

There are many Excel how-to videos on Youtube

Watch this 5 min video:

How to setup a data validation drop down list:

 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data validation list 17
Drop-down list and error message 1
Using a drop-down box to sort data based on seperate columns 2
Drop down list from index/match formula 1
Dymanic List Range 2
drop down list 1
Data Validation and drop-down list using IF, AND and what else? 8
adding elements to an existing list 4

Top