Want to Create a List in Excel 2002; Don't see List in Data Menu?
 

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!

Want to Create a List in Excel 2002; Don't see List in Data Menu?
 

Highlight your range, then go to "Insert", "Name" and select "Define".

"Manoj" wrote:

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!

Want to Create a List in Excel 2002; Don't see List in Data Menu?
 

Manoj

DataCreate 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
wrote:

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!