How do you create a drop-down menu within a cell in Excel?

How do you create a drop-down menu within a cell in Excel?

You can use data validation. There are instructions in Excel's Help, and
here:

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

Jimmy wrote:
> How do you create a drop-down menu within a cell in Excel?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

First select the cell(s) that you want the drop down to be in.

Data>Validation and then choose List from the Allow: box.
Then add the source of the data.

Have a look here for more info,
http://www.contextures.com/xlDataVal01.html#Dropdown

Hywel
Manchester UK