Excel rows to columns question!

[oly]

2. I have some long labels on a spreadsheet. Instead
of having them spill across columns, or get cut off
because the column is too narrow and the next cell has
content, I want to keep the column width the same but
allow the text to take up as many lines as it needs, in
the same cell. How do I do that?

 

[Gord Dibben]

oly

Try Format>Cells<Alignment "Wrap Text".

Note: this will increase the height of your rows in which you have text that
will not fit across one column of fixed width.

Gord Dibben XL2002

 

[GB]

Format....cells.... alignment tab ..... tick wrap text box.