Too much data in one cell
 

I have a rather large spreadsheet that contains several non-adjacent cells in
a given column that contain a large amount of data, stretching the column way
too wide.

Is there a way to force the data to break into two or more lines within a
given cell?

Using Excel 2003.

Thanks.

JT

Too much data in one cell
 

Yes. Position your cursor in the data in a cell where you want a line break
to occur and press Alt+Enter

Tyro

"JT" wrote in message
...
I have a rather large spreadsheet that contains several non-adjacent cells
in
a given column that contain a large amount of data, stretching the column
way
too wide.

Is there a way to force the data to break into two or more lines within a
given cell?

Using Excel 2003.

Thanks.

JT

Too much data in one cell
 

You can set the cell's format to "wrap text".

If you want an in-cell linefeed use Alt + Enter to break where you wish.


Gord Dibben MS Excel MVP

On Thu, 28 Feb 2008 18:43:05 -0800, JT wrote:

I have a rather large spreadsheet that contains several non-adjacent cells in
a given column that contain a large amount of data, stretching the column way
too wide.

Is there a way to force the data to break into two or more lines within a
given cell?

Using Excel 2003.

Thanks.

JT