Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wont wrap
This is so basic im embarrassed to ask becausde I cant get this working.
Ive a cell with text in it too long for the cell B35. Ive formatted the cell to wrap text, number alignment is general and used autofit but it still won't display all the text in cell B35. I have other cells where i have the same issue and other cells where the wrapping has worked properly. I don't think there is a max number of text in a cell. I am sure that ive done more than this particualr cell that wont wrap before? Thank Cari Rambo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wont wrap
Excel will show about 1000 characters in a cell--unless you do something to see
more. Try adding alt-enters (to force newlines within the cell) every 80-100 characters to see lots more than those 1000 characters. Rambo wrote: This is so basic im embarrassed to ask becausde I cant get this working. Ive a cell with text in it too long for the cell B35. Ive formatted the cell to wrap text, number alignment is general and used autofit but it still won't display all the text in cell B35. I have other cells where i have the same issue and other cells where the wrapping has worked properly. I don't think there is a max number of text in a cell. I am sure that ive done more than this particualr cell that wont wrap before? Thank Cari Rambo -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text wont wrap
If the cell is not more than the 100 characters Dave mentions, perhaps it is a
"merged" cell. These will wrap but not autofit. Gord Dibben MS Excel MVP On Thu, 6 Mar 2008 09:16:00 -0800, Rambo wrote: This is so basic im embarrassed to ask becausde I cant get this working. Ive a cell with text in it too long for the cell B35. Ive formatted the cell to wrap text, number alignment is general and used autofit but it still won't display all the text in cell B35. I have other cells where i have the same issue and other cells where the wrapping has worked properly. I don't think there is a max number of text in a cell. I am sure that ive done more than this particualr cell that wont wrap before? Thank Cari Rambo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text doesn't wrap | Excel Worksheet Functions | |||
Date format from excel to CVS file wont. Change in CVS wont stay. | Excel Worksheet Functions | |||
Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) |