J
Jamie
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?
"list" is not an option under it. What should I do?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Conrad Carlberg
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.
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.
D
Dave Peterson
Data|List was added in xl2003.
What version of excel are you using?
What version of excel are you using?
L
LVictory
THe answers posted do not fix the problem. I am running 2003XP and Data/List
is not an option.
is not an option.
P
protonLeah
I'm using XL-2000-, and 'LIST' is found at DATA|VALIDATION|ALLOW:LIST.
P
protonLeah
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
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