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?

Use alt+enter to effect a line break w/in a cell. Lots of spaces would not
only be tedious, but would be dependent on the column width.

"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?

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?