Create a list range

I need to create a list range
Under data, point to list and then create list.
I do not have list listed under data.
Where can it be found?

Hi

Data> Validation. Select 'List' in 'Allow' field. Into 'Refers to' field, or
enter list values separated by your list separator, or enter the link to
cell range on same worksheet, or enter the link to any named range in same
workbook.


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )



"Brick72" <Brick72@discussions.microsoft.com> wrote in message
news:A1201D85-0597-47BE-A7E1-A6C5DF5C13F4@microsoft.com...
>I need to create a list range
> Under data, point to list and then create list.
> I do not have list listed under data.
> Where can it be found?

Perhaps Tools>Create a List.


Gord Dibben Excel MVP

On Wed, 5 Oct 2005 19:05:02 -0700, "Brick72"
<Brick72@discussions.microsoft.com> wrote:

>I need to create a list range
>Under data, point to list and then create list.
>I do not have list listed under data.
>Where can it be found?