Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Matthias Klaey
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 12:46 PM
Excel 2003 Filter Problem bkbrueggemann Excel Discussion (Misc queries) 3 February 2nd 05 12:49 AM
Excel 2003 hyperlink problem GregL Links and Linking in Excel 0 January 16th 05 05:03 AM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 14th 04 12:51 AM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"