Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2003 Filter Problem | Excel Discussion (Misc queries) | |||
Excel 2003 hyperlink problem | Links and Linking in Excel | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |