how do i create a list from a cell?

[AT]

Instead of typing 20 product models in a cel like this a, b, c, d, e, f, g,
h,...
i see someone create a list from a cell, so once you select that cell, the
formular bar will show a list of products like this:
a
b
c
d
e
....

 

[Frank Kabel]

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

 

[Debra Dalgleish]

You can type a model name, then enter a line break
To type a line break, hold the Alt key, and press the Enter key