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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 "Insert", "Name" and select "Define".
 
Manoj

Data>Create List was introduced with Excel 2003.

Suggest you use a named range.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Missing list menu 1
Dependent list in excel to create validation 1
Create Drop Down List of Macros 1
Does Excel 2002 have a List>Create List option under Data? 3
Creating a list from a different worksheet 1
Data Validation List Not Working Correctly 5
Data/Subtotal 1

Back
Top