JLatham said:It sounds like you have the general idea of things, perhaps just carrying
them out in the wrong order?
This process will work whether the list of 84 cells (which will make up the
list shown in the cell we'll set up Data Validation for later) is on the same
sheet with the data validation cell or not.
You need to know where the Name Box is: it is the display area just above
the column identifier A and above the '1' identifier for row 1. It usually
shows the address of the cell you currently have selected.
So go and select all 84 cells and give them a name by typing a name such as
myList into the name box while those cells are selected. After typing in the
name you MUST press the [Enter] key or Excel will forget the name.
Now go to the cell you want the list to show up in. Choose Data |
Validation and for "Allow" - choose List. For "source" type in =myList and
click [OK]. That should be all there is to it. Now when you click in that
cell it should make the list of 84 entries available for you to select from.
NOTE: if your list of 84 names is on a different sheet than the one you were
trying to set up data validation for, that would explain why it wouldn't
work. Ordinarily the list has to be on the same sheet with the cell using
data validation. But by assigning a name to the range, the list can be in
any sheet in the workbook.
Hope this helps.
Eulalia Ledesma said:How do I create a drop down list?
I have a list of 84 cells and I want to create a drop down list. I tried
doing the list and validating the data, but it still does not work.
Please help!!
me said:thanks!!
I did it and it does not work if I keep just the first cell and erase the
cells down.
is it there any other way?
these are values in each cell;
If I give the values will you be able to help me?
JLatham said:It sounds like you have the general idea of things, perhaps just carrying
them out in the wrong order?
This process will work whether the list of 84 cells (which will make up
the
list shown in the cell we'll set up Data Validation for later) is on the
same
sheet with the data validation cell or not.
You need to know where the Name Box is: it is the display area just above
the column identifier A and above the '1' identifier for row 1. It
usually
shows the address of the cell you currently have selected.
So go and select all 84 cells and give them a name by typing a name such
as
myList into the name box while those cells are selected. After typing in
the
name you MUST press the [Enter] key or Excel will forget the name.
Now go to the cell you want the list to show up in. Choose Data |
Validation and for "Allow" - choose List. For "source" type in =myList
and
click [OK]. That should be all there is to it. Now when you click in
that
cell it should make the list of 84 entries available for you to select
from.
NOTE: if your list of 84 names is on a different sheet than the one you
were
trying to set up data validation for, that would explain why it wouldn't
work. Ordinarily the list has to be on the same sheet with the cell
using
data validation. But by assigning a name to the range, the list can be
in
any sheet in the workbook.
Hope this helps.
Eulalia Ledesma said:How do I create a drop down list?
I have a list of 84 cells and I want to create a drop down list. I
tried
doing the list and validating the data, but it still does not work.
Please help!!
Peo Sjoblom said:Why would you "erase" the cells, the whole idea is that you use a list that
can be hidden if necessary, refer to that list and put the dropdown in
another cell. Not that you put the validation in the first cell of the list
and delete the rest of the list, for obvious reasons you cannot use a list
that does not exist
--
Regards,
Peo Sjoblom
me said:thanks!!
I did it and it does not work if I keep just the first cell and erase the
cells down.
is it there any other way?
these are values in each cell;
If I give the values will you be able to help me?
JLatham said:It sounds like you have the general idea of things, perhaps just carrying
them out in the wrong order?
This process will work whether the list of 84 cells (which will make up
the
list shown in the cell we'll set up Data Validation for later) is on the
same
sheet with the data validation cell or not.
You need to know where the Name Box is: it is the display area just above
the column identifier A and above the '1' identifier for row 1. It
usually
shows the address of the cell you currently have selected.
So go and select all 84 cells and give them a name by typing a name such
as
myList into the name box while those cells are selected. After typing in
the
name you MUST press the [Enter] key or Excel will forget the name.
Now go to the cell you want the list to show up in. Choose Data |
Validation and for "Allow" - choose List. For "source" type in =myList
and
click [OK]. That should be all there is to it. Now when you click in
that
cell it should make the list of 84 entries available for you to select
from.
NOTE: if your list of 84 names is on a different sheet than the one you
were
trying to set up data validation for, that would explain why it wouldn't
work. Ordinarily the list has to be on the same sheet with the cell
using
data validation. But by assigning a name to the range, the list can be
in
any sheet in the workbook.
Hope this helps.
:
How do I create a drop down list?
I have a list of 84 cells and I want to create a drop down list. I
tried
doing the list and validating the data, but it still does not work.
Please help!!
me said:I just want to as when you are in a WEB page let's say for the US States
you
get a drop dwn list but not all the States are shown on the cell below.
Do you undederstand what I mean?
Peo Sjoblom said:Why would you "erase" the cells, the whole idea is that you use a list
that
can be hidden if necessary, refer to that list and put the dropdown in
another cell. Not that you put the validation in the first cell of the
list
and delete the rest of the list, for obvious reasons you cannot use a
list
that does not exist
--
Regards,
Peo Sjoblom
me said:thanks!!
I did it and it does not work if I keep just the first cell and erase
the
cells down.
is it there any other way?
these are values in each cell;
If I give the values will you be able to help me?
:
It sounds like you have the general idea of things, perhaps just
carrying
them out in the wrong order?
This process will work whether the list of 84 cells (which will make
up
the
list shown in the cell we'll set up Data Validation for later) is on
the
same
sheet with the data validation cell or not.
You need to know where the Name Box is: it is the display area just
above
the column identifier A and above the '1' identifier for row 1. It
usually
shows the address of the cell you currently have selected.
So go and select all 84 cells and give them a name by typing a name
such
as
myList into the name box while those cells are selected. After typing
in
the
name you MUST press the [Enter] key or Excel will forget the name.
Now go to the cell you want the list to show up in. Choose Data |
Validation and for "Allow" - choose List. For "source" type in
=myList
and
click [OK]. That should be all there is to it. Now when you click in
that
cell it should make the list of 84 entries available for you to select
from.
NOTE: if your list of 84 names is on a different sheet than the one
you
were
trying to set up data validation for, that would explain why it
wouldn't
work. Ordinarily the list has to be on the same sheet with the cell
using
data validation. But by assigning a name to the range, the list can
be
in
any sheet in the workbook.
Hope this helps.
:
How do I create a drop down list?
I have a list of 84 cells and I want to create a drop down list. I
tried
doing the list and validating the data, but it still does not work.
Please help!!
Peo Sjoblom said:No I don't understand, but here are instructions
http://www.contextures.com/xlDataVal01.html
You can even download a sample
--
Regards,
Peo Sjoblom
me said:I just want to as when you are in a WEB page let's say for the US States
you
get a drop dwn list but not all the States are shown on the cell below.
Do you undederstand what I mean?
Peo Sjoblom said:Why would you "erase" the cells, the whole idea is that you use a list
that
can be hidden if necessary, refer to that list and put the dropdown in
another cell. Not that you put the validation in the first cell of the
list
and delete the rest of the list, for obvious reasons you cannot use a
list
that does not exist
--
Regards,
Peo Sjoblom
thanks!!
I did it and it does not work if I keep just the first cell and erase
the
cells down.
is it there any other way?
these are values in each cell;
If I give the values will you be able to help me?
:
It sounds like you have the general idea of things, perhaps just
carrying
them out in the wrong order?
This process will work whether the list of 84 cells (which will make
up
the
list shown in the cell we'll set up Data Validation for later) is on
the
same
sheet with the data validation cell or not.
You need to know where the Name Box is: it is the display area just
above
the column identifier A and above the '1' identifier for row 1. It
usually
shows the address of the cell you currently have selected.
So go and select all 84 cells and give them a name by typing a name
such
as
myList into the name box while those cells are selected. After typing
in
the
name you MUST press the [Enter] key or Excel will forget the name.
Now go to the cell you want the list to show up in. Choose Data |
Validation and for "Allow" - choose List. For "source" type in
=myList
and
click [OK]. That should be all there is to it. Now when you click in
that
cell it should make the list of 84 entries available for you to select
from.
NOTE: if your list of 84 names is on a different sheet than the one
you
were
trying to set up data validation for, that would explain why it
wouldn't
work. Ordinarily the list has to be on the same sheet with the cell
using
data validation. But by assigning a name to the range, the list can
be
in
any sheet in the workbook.
Hope this helps.
:
How do I create a drop down list?
I have a list of 84 cells and I want to create a drop down list. I
tried
doing the list and validating the data, but it still does not work.
Please help!!