how do i create a list from a cell?
 

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
....

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

--
Regards
Frank Kabel
Frankfurt, Germany
"AT" schrieb im Newsbeitrag
...
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
...

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


AT wrote:
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
...



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