Making a list inside a cell

[Fedde]

Hello,

I'd like to make a list inside a cell, in which you can choose the
sentence you would like to have into that specific cell.
For example:
I would like to have the following list into, say, cell F4:
- Tree
- Leaves
- Root
- Twig
- Oak

Is this possible to make?

 

[cycling-rod]

Instructions for creating a drop-down list is here:
http://www.beyondtechnology.com/tips018.shtml

 

[Fedde]

Hey thanks

 

[gls858]

Hello,

I'd like to make a list inside a cell, in which you can choose the
sentence you would like to have into that specific cell.
For example:
I would like to have the following list into, say, cell F4:
- Tree
- Leaves
- Root
- Twig
- Oak

Is this possible to make?

Check Excel Help for drop-down list. The instruction are pretty
straight forward. Post back if you need more help.

gls858

 

[paul]

the combo box from the forms toolbar will also give you a list.Its advantage
to me is that the drop down is always visible whereas the validation list
only shows when you navigate to the cell