software

I want to create a List range in a data-set. I am using Excel 2002. When I am
going to Data Menu; there is nothing like the LIST option. Please suggest!

Highlight your range, then go to quot;Insertquot;, quot;Namequot; and select quot;Definequot;.

quot;Manojquot; wrote:

gt; I want to create a List range in a data-set. I am using Excel 2002. When I am
gt; going to Data Menu; there is nothing like the LIST option. Please suggest!

Manoj

Datagt;Create List was introduced with Excel 2003.

Suggest you use a named range.Gord Dibben MS Excel MVP

On Thu, 6 Apr 2006 11:03:02 -0700, Manoj gt;
wrote:

gt;I want to create a List range in a data-set. I am using Excel 2002. When I am
gt;going to Data Menu; there is nothing like the LIST option. Please suggest!