Drop Down Menu

[TJAC]

In Excel 2002 I'm trying to create a drop down menu in one column. For each
cell in this column, it should be a drop down menu with a menu of about 7
different choices. I can't find the steps on how to create this. Would I
have to create a drop down object in each cell? If anyone can give me a good
site with steps on how to do this or tell me through this posting, I would
really appreciate it!

Thanks,

[Ron Coderre]

Here's where you want to go:

http://www.contextures.com/xlDataVal01.html

***********
Regards,
Ron

XL2002, WinXP-Pro


"TJAC" wrote:

> In Excel 2002 I'm trying to create a drop down menu in one column. For each
> cell in this column, it should be a drop down menu with a menu of about 7
> different choices. I can't find the steps on how to create this. Would I
> have to create a drop down object in each cell? If anyone can give me a good
> site with steps on how to do this or tell me through this posting, I would
> really appreciate it!
>
> Thanks,

[Dave Peterson]

You could use data|Validation

Debra Dalgleish has some notes at:
http://www.contextures.com/xlDataVal01.html

TJAC wrote:
>
> In Excel 2002 I'm trying to create a drop down menu in one column. For each
> cell in this column, it should be a drop down menu with a menu of about 7
> different choices. I can't find the steps on how to create this. Would I
> have to create a drop down object in each cell? If anyone can give me a good
> site with steps on how to do this or tell me through this posting, I would
> really appreciate it!
>
> Thanks,

--

Dave Peterson