Scott

Type a name the hit Alt + Enter.

Type another name then hit Alt + Enter

The Alt + Enter gives you a hard return in the cell.

Alternative........in a helper cell enter this formula

=A1 & CHAR(10) & A2 & CHAR(10) & A3....etc.


Gord Dibben MS Excel MVP

On Fri, 16 Feb 2007 08:22:15 -0800, Scott@CW
wrote:

I need to make a list of names appear in a vertical list in one cell. I
cannot just merge a series of cells together, this is a preformatted
worksheet template. Is there a way to do this without just hitting the space
bar until it drops down in the cell?