If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003 - Text Import Wizard problem. | LEXCERM | General Discussion | 1 | October 12th, 2004 10:17 PM |
Problems with LINEST in Excel 2003 | hypersonic | Worksheet Functions | 1 | August 17th, 2004 10:36 PM |
Ctrl+A macro fix for problem in Excel 2003 | David McRitchie | General Discussion | 4 | June 19th, 2004 12:01 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
Excel Application for Office 2002 displays error in Office 2003 | kaustav choudhury | Setting up and Configuration | 3 | February 10th, 2004 02:29 AM |