View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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