![]() |
Row Autofit problem Excel 2003
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 |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com