I wonder if anyone can reproduce the following:
1. Create a new Excel workbook, select cell A1 on sheet1.
2. In menu Format/Cells/Alignment select Vertical:Top
and check Wrap Text.
3. In the formatting toolbar, select Font Verdana 10pt.
4. Type "This is my text" int the cell.
It should wrap "my text" to the second line.
5. In menu Format / Row, select Autofit.
6. Preview or print the worksheet.
The problem: About half of the bottom of the second line "my text" is
cut off.
I noticed two things: First, the problem occurs with any selection of
the vertical alignement except for Vertical:Bottom.
Second, the font Verdana is not listed in the menu Format/Cells on the
Font Tab.
Questions: 1. Can you reproduce this? 2. Is there a way around this
problem without losing the automatic reformatting of the cell height
when additional text is filled in?
Background: I have a worksheet that is being reused by the users to
type in text in several columns. Sometimes the text wraps, somtimes
not. The only sensible way do display this worksheet is to align the
text vertically at the top. Due to this problem, one has to adjust row
heights by hand, which is extremely tedious. And, I cannot use the
Arial font, where the problem does not occur.
Thank you
Matthias Kläy
--
www.kcc.ch