thread68-1285735
To reiterate what has been said about this issue on this and other forums, this is an issue with extra white space in Excel cells with Text Wrap on using AutoFit Row Height. This is not a merged cell issue, and it is not related to hidden Alt-Enter characters. If the vertical cell alignment is Top, the extra space appears at the bottom. Likewise, if the vertical alignment is Bottom, the extra space appears at the top. When you really need the text to be wrapped, and your design already maximizes the full printable area, you don't have room on a printed page for AutoFit Column Width, and so in that case the "AutoFit Column" and "No Text Wrap" solutions don't work.
My experimentation has determined that this is an issue with the relationship between font rendering and text-wrapping in Excel, similar to the IE6 text-wrapping bug for italics in table cells: the font's rendered space is slightly larger than the defined space, but the difference is not enough to trigger text-wrapping.
One hackish way to solve this is to look for columns that have text right up against the line and reduce that column's width so that text-wrapping is triggered. For large documents, it may be difficult to find a width that will fix this issue in all instances. Once text-wrapping is triggered in this way, the extra white space in the adjacent columns (with text-wrapping and AutoFit Row Height on) will disappear.
Any ideas for a more elegant solution, or guesses when this Excel bug might be fixed?
To reiterate what has been said about this issue on this and other forums, this is an issue with extra white space in Excel cells with Text Wrap on using AutoFit Row Height. This is not a merged cell issue, and it is not related to hidden Alt-Enter characters. If the vertical cell alignment is Top, the extra space appears at the bottom. Likewise, if the vertical alignment is Bottom, the extra space appears at the top. When you really need the text to be wrapped, and your design already maximizes the full printable area, you don't have room on a printed page for AutoFit Column Width, and so in that case the "AutoFit Column" and "No Text Wrap" solutions don't work.
My experimentation has determined that this is an issue with the relationship between font rendering and text-wrapping in Excel, similar to the IE6 text-wrapping bug for italics in table cells: the font's rendered space is slightly larger than the defined space, but the difference is not enough to trigger text-wrapping.
One hackish way to solve this is to look for columns that have text right up against the line and reduce that column's width so that text-wrapping is triggered. For large documents, it may be difficult to find a width that will fix this issue in all instances. Once text-wrapping is triggered in this way, the extra white space in the adjacent columns (with text-wrapping and AutoFit Row Height on) will disappear.
Any ideas for a more elegant solution, or guesses when this Excel bug might be fixed?