A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Row Autofit problem Excel 2003



 
 
Thread Tools Display Modes
  #1  
Old January 19th, 2005, 05:33 PM
Matthias Klaey
external usenet poster
 
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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.