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,