Hello, a very basic question about Excel 2003.

Does Excel have a method of letting you use a drop-down menu to select
data that's already been entered in a column?

I'd like to streamline my selecting a piece of information, and I
figured a drop-down menu might be the simplest way. I know Excel has
an auto-complete feature, but if a drop-down menu, based on data
already entered in a column, can be created, I'd prefer that.

If this is possible, without macros or VBA code, or anything like
that, what's the procedure?

If it's not possible, that's all right. Thank you!

Jd