Is it possible in Excel to create a category list in once cell?
What I am trying to do is in one cell, say A1, will have a question such as
Year of Birth. Would it be possible in Cell B1 to create a list from 1950 -
1990 and be able to choose a relevant year and the choice made will show in
cell B1?

Thanks in advance,

Hi Greenback,

Would it be possible in Cell B1 to create a list from 1950 -
1990 and be able to choose a relevant year and the choice made will show in
cell B1?

Data, Validation is what you're after!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Thanks for the prompt reply Jan Karel
I had a look at it but don't quite understand. Could you please give me an
example of how this can be done?

Thanks

"Jan Karel Pieterse" wrote:

Hi Greenback,

Would it be possible in Cell B1 to create a list from 1950 -
1990 and be able to choose a relevant year and the choice made will show in
cell B1?

Data, Validation is what you're after!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Hi Greenback,

I had a look at it but don't quite understand. Could you please give me an
example of how this can be done?

Sure. First, create a list of the numbers 1950 to 1990 anywhere in your
workbook (might be good to use a dedicated worksheet just for that purpose).
Then select the numbers and choose Insert, Name, Define and enter a
descriptive name, e.g. Years.

Next, select your range of cells that you want to have that dropdown choice
for and choose Data, Validation, list option. In the Source box, type

=Years

(replace with the name you used in "insert, name, define")

And then on the other tabs of the dialog fill in the other details.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Just to add to Jan's post.

To minimize scrolling you can add a single number at the beginning of each
decade in your list. So 1950 would have a 5 above it, 1960 would have a 6
and so on and a 9 above 1990.

Then if you are going to select 1966, enter a 6 in the list cell and DO NOT
hit enter. Just click on the down arrow and you will be at the top of the
60's decade list.

(You can hit enter and it will still work, but you have to reselect the
cell)

HTH
Regards,
Howard


"Greenback" wrote in message
...
Is it possible in Excel to create a category list in once cell?
What I am trying to do is in one cell, say A1, will have a question such
as
Year of Birth. Would it be possible in Cell B1 to create a list from
1950 -
1990 and be able to choose a relevant year and the choice made will show
in
cell B1?

Thanks in advance,

Jan and L. Howard
just back from vacation and tried what you suggested. Absolutely what I
needed.
Thanks to you both for your assistance.

much appreciated

"L. Howard Kittle" wrote:

Just to add to Jan's post.

To minimize scrolling you can add a single number at the beginning of each
decade in your list. So 1950 would have a 5 above it, 1960 would have a 6
and so on and a 9 above 1990.

Then if you are going to select 1966, enter a 6 in the list cell and DO NOT
hit enter. Just click on the down arrow and you will be at the top of the
60's decade list.

(You can hit enter and it will still work, but you have to reselect the
cell)

HTH
Regards,
Howard


"Greenback" wrote in message
...
Is it possible in Excel to create a category list in once cell?
What I am trying to do is in one cell, say A1, will have a question such
as
Year of Birth. Would it be possible in Cell B1 to create a list from
1950 -
1990 and be able to choose a relevant year and the choice made will show
in
cell B1?

Thanks in advance,