| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create an automatic complete list from existing data in the sheet | Excel Discussion (Misc queries) | |||
| How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
| Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
| How to..use worksheet form and save data to an Excel list | Excel Discussion (Misc queries) | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
Linear Mode
