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<attarkon.ee )



"Brick72" wrote in message
...
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 ToolsCreate a List.


Gord Dibben Excel MVP

On Wed, 5 Oct 2005 19:05:02 -0700, "Brick72"
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?