Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
moving data to a cell, not pulling data to the cell | Excel Worksheet Functions | |||
cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) |