Format List

S

Scott@CW

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

bpeltzer

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

Gord Dibben

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
 
Top