multiple lines in a cell

C

charles

Does anyone know how to put multiple lines in a cell that is high enough for
more than one line?
charles arnett
 
M

Maistrye

charles said:
Does anyone know how to put multiple lines in a cell that is high enough
for
more than one line?
charles arnett
Click to expand...

Two possibilities:

1) When you're typing, hit ALT-ENTER to keep typing on a new line for
the same cell.

2) If you just want the text to wrap to the next line when you're
typing, go to Format -> Cells... Select Alignment, check off the Wrap
text cell, and hit OK. (As long as you haven't merged the cell, it
will automatically resize. If you've merged, you'll possibly have to
manually resize the cell.)

Scott
 
T

Tara H

Right-click and select Format Cells, then in the Alignment tab tick the Wrap
text box under Text contol.

Hope this helps.

Tara
 
Top