Validation drop down list header problem

[Dave]

I have created a data validation rule in some cells of a worksheet giving me
a drop down box to choose from a list which is located on another worksheet.
However, the 'header' of the list appears as one of the drop down choices
and this should not be.
Any help is much appreciated

 

[WLMPilot]

You don't identify how you reference the data in list. One way is to NAME
the range of cells (leaving out the header). Then on the Validation List,
just put =LIST in the Source Box. You don't have to reference the worksheet
if different.

Also check out: http://www.contextures.com/xlDataVal03.html

Les

 

[Bob Phillips]

Don't include it in the list then, maybe put the text in the cell above, or
in the input message.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave]

When creating the list I chose the option ticked the box to say that the
'list has a header'. Then I highlighted the list and named it.
At what stage should I leave out the header?
I tried creating a list with out a header, but then excel inserts a header
'column1' which then appears as a choice on the drop down list!
thanks

 

[Gord Dibben]

Do not create the list using the Data>List>Create list which I believe you are
doing.

Just select the range of cells to include in the DV list and Insert>Name>Define.

Give it a name then use that name in DV source.........=MyList


Gord Dibben MS Excel MVP