trouble with drop down list

  • Thread starter Thread starter gmwshop
  • Start date Start date
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.
 
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
 
There are many Excel how-to videos on Youtube

Watch this 5 min video:

How to setup a data validation drop down list:

 
Back
Top