Auto Row Height problem

One column of my worksheet is a Description column containing text
(sometimes several sentences). It has been edited many times. When I select
the entire worksheet and select Format, Row, AutoFit, some of the rows get
the proper height but many either get one extra line added (no, there is not
an extra return in the cells) or some of the text gets cut off (hidden below
the bottom border). I currently have to check every row of this 20 page
document to ensure the row heights are correct - is there a better way to
adjust the row heights? (I am using Excel 2000 and 2002.)

Vivian Carroll

vcvc (2)
5/31/2004 7:19:09 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 23

>>is there a better way to adjust the row heights?

I don't think so. It is an Excel annoyance that autofit sometimes gives you 
more row height than it seems you need visually.  Also that Excel will 
display only about a thousand characters in a cell even though a cell can 
contain over 32 thousand characters.  And then there is the merged cell 
problem.  If you have any merged cells Excel will ignore them when you do an 
autofit.  For these reasons manually adjusting row heights is sometimes the 
only answer.

Jim Rech
Excel MVP
"Vivian Carroll" <> wrote in message 
> One column of my worksheet is a Description column containing text
> (sometimes several sentences). It has been edited many times. When I 
> select
> the entire worksheet and select Format, Row, AutoFit, some of the rows get
> the proper height but many either get one extra line added (no, there is 
> not
> an extra return in the cells) or some of the text gets cut off (hidden 
> below
> the bottom border). I currently have to check every row of this 20 page
> document to ensure the row heights are correct - is there a better way to
> adjust the row heights? (I am using Excel 2000 and 2002.)
> TIA,
> Vivian Carroll

jrrech (1932)
5/31/2004 9:06:41 PM

Similar Artilces:

Comments problem
I've created a number of comments. When I position the comments where I want them, they only reflect their positions on "Show" or "Edit" comment. All the comments default to the same relationship to the cells when you pass over them. This is a problem because I've also used data vaildation (with lists) on these cells and you can't display the comment with the list pulled down at the same time because the comments are tool close to the validated cell. Thanks in adavance. The comment usually appears to the right of the cell, and should still allow you to see t...

Excel Mail Merger Problem
When merging excel with word currrency field is dropping off zeros to the right of decimal point..if field has $ 56.03, it imports correctly, but if it is $56.00, it comes in as $56, if it is $56.30, it comes in as $56.3...this process is for invoices..any advice (I've tried everything)? Debra Dalgleish has given the following reply in newsgroups and has also identified the following MS KB articles in such as : 304387 - WD: Date, Phone N...

synchronising problem with Sony NWZ-S545
Up until recently i could sync tracks/albums etc to my sony S545 MP3. now when i try and drag tracks to the sync folder then click start sync the mp3 player just freezes, WMP states "processing" but nothing happens. Have searched the web for a solution but nothing. done sysem restore etc etc. I guess it must be a recent update but what one? Its a pain in the backside and hope someone can help "Wookywoo" wrote: > Up until recently i could sync tracks/albums etc to my sony S545 MP3. now > when i try and drag tracks to the sync folder then click s...

Printing problem from Excel 2007
Greetings, I am having an issue with printing from Excel 2007. Many users when printing from Excel with get several pages of non-sensical "junk" printed out on the pages. If it actually prints what is on the page, none of the items are in the cells, but look like they are just randomly thrown about the page. I have found that this most often is related to the Calibri font somehow, because I instruct them to change the font to Arial and all prints fine. That being said, if the user converts the Excel sheet into a PDF and print, it prints perfect. This is a great workaround, but kind ...

Problems printing in Publisher 2003 with HP PSC 2410 #2
I am new to publisher 2003 and am having great difficulties printing anything properly using an HP PSC 2410 all in one. As an example when trying to print a half page side folded pre-designed greetings card all that prints is page 1 and part of page 4, minus any text. Pages 2 and 3 are missing altogether. The print preview however displays everything correctly. I have reinstalled Office 2003 and updated the printer drivers to the latest versions but the problem remains. Any help is much appreciated. ...

Inserting a Row from a UserForm
Hi guys- I'm kind of a self-taught VBA programmer and I can usually blunder around and get a macro to work, but I'm having trouble with a rather difficult one right now. I've created a UserForm that has 6 fields the user has to fill in for a database. Once the user hits the "OK" button, I want the macro to look for the last entry in the database that is identical to what the user filled in Field 1 of the UserForm and insert a row beneath it and fill in the cells with the data from the UserForm. So, i.e: Apple Apple Orange Orange Orange Banana Grape Grape If I type &...

want to do piovt table, where rows over 100,000
Hi.. i have around 100,000 rows of data... of cousres the worksheet i can only put 66000 or so rows per sheet. i want to do a pivot table that combines the two sheets. how can i do this? thank -- Message posted from Hi if you have that many data I would suggest you store this data in a real database (e.g. MS Access). With Excel's pivot table wizard you can then access this database as datasource. Another way would be to split the data in two worksheets and within the pivot table wizard choose the 'non contigenous ranges' for the data source -- Reg...

code problem
Hi this is a follow on to a previous thread (Copy Macro) We are now successfully creating a new Workbook using the code below. With ActiveWorkbook FName = .Path & "\code.txt" .VBProject.VBComponents("Module2_sort").Export FName End With ThisWorkbook.Worksheets(Array("Supplier Concerns")).Copy ActiveWorkbook.SaveAs Filename:="c:\Week\testing" & strFileName & ".xls" ActiveWorkbook.VBProject.VBComponents.Import FName Problem is when we open the new Workbook and run the macro the code defaults ba...

conversion lotus 123 files to excel -- problem
I am converting lotus123 files to excel2002. One problem is that in lotus, literals are ignored when found in a cell within a formula. Excel on the other hand is not doing this and therefore causing #value errors on all the formulas where this occurs. Is there a way to handle this in excel other than manually having to change all the formulas? ...

Convert Column to row with variable data
Hi I'm using Excel 2k and I have a spreadsheet that looks like this Name Address Fred 21 Blah St London Sue Tower 50 London EC2 and need it to look like this Name Address 1 Address2 Address3 Fred 21 Blah St London Sue Tower 50 London EC2 I have a macro that can convert from column to row but only for a set number of columns. Is there any way to account for the variable amount of data for each address ? Any help much appreciated Thanks David David: I suggest the following formulae - copied down as necessary: C2: =IF(...

Access, average several fields in one row
I have several rows of data in a field, I need to average all the entries in one row I have 12 fields for 12 months of data, I need the average of the sum of all non blank entries. For example 3 months completed, the solution in Excel is (field1+field2+field3)/3 I am looking for method to average the sum in Access One way if you can't change your data is to use a VBA function. I've posted one below. You would call it in a calculated field in a query. Assuming your field names are the abbreviated month names the expression might look like the following. Field: fRow...

Page Number in Repeat Rows area
Is there a way that I can put a Page Number in the Repeat Rows area of a sheet - and get it to update when I print? I have found one piece of VBA that puts a page number within a cell but it is only updated if the cell is outside the Repeat Row area. When it is within the Repeat Rows area I just get a page number of 1 corresponding to the original row location.. I do some VBA programming but am not an expert. TIA cheers Chris Nothing comes to mind that doesn't require VBA code. You can paste the following in the sheet header (File | Page Setup) and page x of y will print on ea...

Auto expanding X Axis for Chart
I have a chart setup, currently with reference to 31 cells width. The chart looks great if the user places a value in each of the 31 cells, however if there are only say 20 values placed across the cell row, the chart is displayed over to one side, with nil values displayed where no dat values were entered. Is there a way to have the chart automatically vary the width depending on the amount of values entered across the refernced row of cells? If there was only 20 values entered, then the chart would show 1-20 charted and leave out the 21-31. Corey.... EXCEL 2007...

problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change the text of some sentences of an opened word file, but the problem is when I change the text of a sentence which located before a table, it will be moved to the first cell of the table. My code is as follow: void myMethod( long startingSentenceNumber, const char *toBeSearched, const char *replacement, bool replace ) { Range currentSentenceRange; Selection sentenceSelection; Sentences sentencesList = m_document.GetSentences(); long sentencesCount = sentencesList.GetCount(); CString replacementCStr(...

reflecting values in a column into a row
I am creating a chart to map a round-robin chess game. If there are 4 players, then all 4 has to play one another. if I have the names John Mike Sally Bill Then I'd like to type them into a columns and write a formula in a row to pick up the names the spreadsheet should then look like this: John Mike Sally Bill John Mike Sally Bill I think it may be achieved with the Indirect() function, but my Excel 2007 help seems broken and I can't figure it out without an example. Thanks. MikeB With names in A2:A5 Enter in B1 =INDIRECT("A"&COLUMN(B1)) Or...

save as problem
I cant save my excel file The "save as" option is not eviable. Whats happening? "From a prior post by Ron DeBruin, You can reset your menubar to default. Right click menubar. Customize > Toolbars Tab. Select worksheet menubar. Click Reset button. Using VBA Application : CommandBars(""Worksheet menu bar"").Controls(""File"").Reset Or the whole menubar Application.CommandBars(1).Reset You lost the things you add to the menubar!!" ========================================================== And one link that offers some sugges...

Odd problem with worksheets when opening file
Okay, here's the odd problem that's come up. When you double click on a excel file, excel opens up, but you can onl see the toolbars. The grid area looks like a snapshot of whatever you current background is before the file opened up. If you were showin your desktop, after the excel file opened, you'd still see your deskto in the datagrid area. If you start up a new excel file, then do the File>Open>file name, th file will open correctly. This problem happens across users here. Everyone is currently runnin office 2K. Any ideas on what causes the problem and any...

Problem OL 2002 Email
I am having a problem with OL 2002 email settings. I have two computers which I am setting up. One computer works perfectly. The second computer I have configured exactly the same...incoming/outgoing servers and ports, etc... are all setup the same. On the second computer when I press test email settings, everything tests fine. But when I try to do a Send/Receive, I run into problems. First, the POP3 tries to connect to the POP3 server twice at the same time. (I am able to see this on my POP3 server console.) Second, the SMTP sending mail never connects to my SMTP server. (Ag...

2007 B2 MSOO has encountered a problem
More often then not when I click to open an email in my inbox I get this MSOO pop-up with a checkbox, checked telling me MSOO has encountered a problem and needs to close. Has this been an issue for others and is there a fix. If you have Adobe Acrobat Pro 6/7 (not the reader), go into Control Panel, Add/Remove Programs, click change for Adobe Acrobat Pro and remove the Office & Outlook plugins. Patrick Schmid -------------- "Jax" <> wrote in message > More of...

Change Row/Column Height & Width
I know I should be able to automatically set a row height to the max necessary by hovering the cursor between the 2 rows I want to adjust and double-clicking, but sometimes this doesn't always work. Why is that that - do I need to adjust a setting? And is there any way to set it so that if text is added or deleted the row height would change automatically so thatthe text fit appropriately? Set the row format to Autofit and cells to Wrap Text Gord Dibben MS Excel MVP On Tue, 19 May 2009 12:14:04 -0700, DaveL <> wrote: >I know I should be ...

Sumproduct Problem (AB)
Hi everyone, can you please sort out this problem for me? SUMPRODUCT(('Client Opening Stock'!B2:B138=$A$1)*('Client Opening Stock'!C2:AH138=A7),'Client Opening Stock'!C2:X138) 'Client Opening Stock'!B2:B138 is the Client Name Client Opening Stock'!C2:AH138 is the Product 'Client Opening Stock'!C2:X138 is the Amount I belive the formula is not the proper formula, but this is the result I need. Thank you for your kind help You need to tell us what the problem is, and what solution you want. Why is it "not the proper formula...

Query Problem in Test.
I keep getting errors on the WHERE part of my query. I'm sure it's something simple. I don't know if you will need the whole code to see what the problem is. It is lengthy, so I will start with just where the problem is. Set rs = DBEngine(0)(0).OpenRecordset("SELECT T2.Distance, T1.* FROM (Church AS T1 INNER JOIN qryChurchZip1 ON T1.ChurchID = qryChurchZip1.ChurchID) INNER JOIN DistanceQuery AS T2 ON qryChurchZip1.Zip5 = T2.ZIPCode WHERE " & strWhere) ' See if found none If rs.RecordCount = 0 Then MsgBox "No Churches meet your crite...

Disabled Auto-numb. Invoice
Hi, I will synchronize Order from SAP to import into CRM with Scribe. My question is: What will happend if CRM Invoice manage itself the auto numbering. May I de-activated the auto numbering? Thanks, Sylvie ...

HTA problem with IE8
We discovered an issue with some inbedded VBScript code inside an HTA written by a developer that is no longer with us. The code work in IE6 but error out on the set objMsgArea statement indicating that the object requires 'objMenuFrame' which should have been set in the previous line of code. If I put in an 'On Error Resume Next" statement in that sub the HTA appears to work correctly however I don't like putting a band-aid on something like this. Does anyone have any solution for this? Here's the code: sub AppStatusDisplay(strMsgIn, bolAddToStatusLogIn) s...

Unable to deliver the message due to a recipient problem #3
Hi can anybody help. I check with varies newsgroup but to no scucess. like for example below When you send mail to an X.400 personal address book (PAB) entry or one-off address, you may receive the following non-delivery report (NDR):... However, this one-off entryis not active in our server. ...