Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Excel wrapping incorrectly
13 views
Skip to first unread message
YPavlov
Oct 29, 2012, 8:18:15 PM10/29/12
to
Hi all-
I am having an issue in some cells of my workbook where cell wrapping isn't behaving correctly. Screenshot of the issue at http://imgur.com/zqXhu (Excel 2007)
In short, Excel does not appear to be correctly recognizing the length of the content correctly, and making the cell two rows high instead of three, and cutting off some of the text ("E1" in this example). The content is a string, no formulas. Making the cell height bigger and then preforming autofit will return the cell to 2 rows high. The cell is a single column wide, not merged.
In some cases, the opposite happens, where excel seems to think that the content needs a third row when it in fact fits on two rows.
Is there any way to get around this limitation?
Thanks in advance!
I am having an issue in some cells of my workbook where cell wrapping isn't behaving correctly. Screenshot of the issue at http://imgur.com/zqXhu (Excel 2007)
In short, Excel does not appear to be correctly recognizing the length of the content correctly, and making the cell two rows high instead of three, and cutting off some of the text ("E1" in this example). The content is a string, no formulas. Making the cell height bigger and then preforming autofit will return the cell to 2 rows high. The cell is a single column wide, not merged.
In some cases, the opposite happens, where excel seems to think that the content needs a third row when it in fact fits on two rows.
Is there any way to get around this limitation?
Thanks in advance!
Alex
Nov 3, 2012, 11:12:58 AM11/3/12
to
YPavlov schreef in news:60b5c6e9-d55e-4d8d...@googlegroups.com
It seems to happen with all versions.
But the first problem is usually solved after closing and reopening the file,
if you didn't change the height manually.
--
Alex.
But the first problem is usually solved after closing and reopening the file,
if you didn't change the height manually.
--
Alex.
0 new messages