Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a list when it is not in the Data tool bar?
I need to create a list, but when I drop down the Data from the tool bar,
"list" is not an option under it. What should I do? |
#2
|
|||
|
|||
Hi Jamie,
Until the most recent XL version, a list was just an informal way of organizing data in a worksheet. It still is, really. It's just a matter of putting different records in different rows, different variables (or "fields") in different columns, and the name of each variable in the list's first row. The column variables should be adjacent to one another, as should the records in the rows. Some Excel features work much more easily, and some work only, with this sort of layout. There is a List command in the Data menu of Excel 2003, which might make things a little easier for you to set your list up, but if you lay your list out correctly you don't need it. -- C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "Jamie" wrote in message ... I need to create a list, but when I drop down the Data from the tool bar, "list" is not an option under it. What should I do? |
#3
|
|||
|
|||
Data|List was added in xl2003.
What version of excel are you using? Jamie wrote: I need to create a list, but when I drop down the Data from the tool bar, "list" is not an option under it. What should I do? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a list when it is not in the Data tool bar?
THe answers posted do not fix the problem. I am running 2003XP and Data/List
is not an option. "Jamie" wrote: I need to create a list, but when I drop down the Data from the tool bar, "list" is not an option under it. What should I do? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a list when it is not in the Data tool bar?
I'm using XL-2000-, and 'LIST' is found at DATA|VALIDATION|ALLOW:LIST. -- protonLeah ------------------------------------------------------------------------ protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097 View this thread: http://www.excelforum.com/showthread...hreadid=472471 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a list when it is not in the Data tool bar?
I'm using XL-2000-, and 'LIST' is found at DATA|VALIDATION|ALLOW:LIST. However, you can always put your list on a scratch sheet and link a dropdown combo box to it, though you'll probably need an INSERT button or some EVENT code along with it. Ben -- protonLeah ------------------------------------------------------------------------ protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097 View this thread: http://www.excelforum.com/showthread...hreadid=472471 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
Trying to Create a Conditional Drop down list | Excel Worksheet Functions | |||
How do I get LIST on the DATA menu bar-I need Create List | New Users to Excel | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |