Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapped text in cells not displaying
I have six workbooks; 5 work fine however the sixth will not display wrapped
text in cells on the main worksheet. The text does wrap, but the row height isn't automatically adjusted to display it all. There are merged cells in the worksheet, but not in the area with the 'wrapped' text. I have manually adjusted the row heights for the whole sheet - would that have an effect? Help! -- Traa Dy Liooar Jock |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapped text in cells not displaying
"I have manually adjusted the row heights for the whole sheet - would that
have an effect?" Yes. Excel will not override a manual adjustment of row height or column width. Tyro "Jock" wrote in message ... I have six workbooks; 5 work fine however the sixth will not display wrapped text in cells on the main worksheet. The text does wrap, but the row height isn't automatically adjusted to display it all. There are merged cells in the worksheet, but not in the area with the 'wrapped' text. I have manually adjusted the row heights for the whole sheet - would that have an effect? Help! -- Traa Dy Liooar Jock |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapped text in cells not displaying
Once you have manually adjusted row height, it will no longer autofit.
You must select and re-apply autofit. Another prpblem might be the amount of text you have in the cell(s). Excel by default will show only 1024 characters in a cell even though you can enter 32767 characters. Add an Alt + Enter linefeed every 80-100 chars if that's the case. Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 10:23:01 -0700, Jock wrote: I have six workbooks; 5 work fine however the sixth will not display wrapped text in cells on the main worksheet. The text does wrap, but the row height isn't automatically adjusted to display it all. There are merged cells in the worksheet, but not in the area with the 'wrapped' text. I have manually adjusted the row heights for the whole sheet - would that have an effect? Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merged Cells and Wrapped Text | Excel Discussion (Misc queries) | |||
Truncated wrapped text cells in Excel | Excel Discussion (Misc queries) | |||
Wrapped text is not displaying in Excel | Excel Discussion (Misc queries) | |||
How do I get all text to print in merged and wrapped cells. | Excel Discussion (Misc queries) | |||
How do I make rows expand to fit wrapped text in cells? | Excel Discussion (Misc queries) |