Free Microsoft Excel 2013 Quick Reference

Excel row height beyond the 409 limit

Excel is limiting the height of rows to 409. I need it to be quite a bit
larger (per content in each row). Does anybody know how I can change this?


Post your answer or comment

comments powered by Disqus
I have an application where it is required for 40 to 50 lines to be in each row.
This is to use a certain macro that compiles data.

So I type a line of data, then press Alt-Enter, type the next line of data, press Alt-Enter, etc.

My problem is that previous users had less than 30 lines of data per row. Having 40 to 50, all the data can not be seen because there seems to be a maximum display height for an excel row.

I drag the bottom row border downward until it won't expand the row height any longer.

Is there a way to expand the row height beyond this limit?

All advice greatly appreciated. Thanks in advance!

How do I get beyond the upper limit of 65,500 records on Excel?

I have a lot of csv files in text that I routinely convert to Excel files,
and sometimes Excel chokes on the size if it gets beyond a certain amount of

Is there a way of getting around this?
I need to be able to display the rows too, besides being able to work with

- Nicholas


I am creating a worksheet and filling the cell values programmatically using VBA.

Is it possible to adjust the row height of the cell based on its contents. I do not want to alter the width size.

Any suggestions??


I have made a calendar and now due to some setting I need to play around with
the heights of the rows. Once I have done this for the first month I would
like to use a function where I can repeat the row heights for the next 11
months - Can anyone help me

In Word, I can create two tables with different column width, then remove
line to combine the two tables together.

Can I achieve the same different column width and row height in the same
worksheet? Either one on top of the other, or side by side?!!

I have a column of data, (Column G) in the attachment, that I am trying to adjust the row height (rows 2 and 3 as examples) using a macro. The data in the cell is divided by carriage returns 'Chr(10)'. AutoFit doesn't work and being that each cell is of varying length I can't give them a one height fits all. Any ideas? Also, has anyone found a way around the 1000 character limit in a cell. This same column (rows 4 and 5) I'm referring to also has this problem and the data will not display.
Thanks in advance

Using Excel 2000. I have a large workbook where several cells contain more text than what Excel wants to view in a cell by default (I've read there is a 1024 character limit). Even with text wrap, the cell would not show all the text. I have forced the view by inserting hard returns (Alt+Enter) at the end of lines and have manually adjusted the row height. This is fine until I do a sort of any kind. Upon a sort, Excel wants to auto-adjust the row height of the large rows back down to some pre-determined default size that will only show a given amount of text. I'm looking for a way to stop the auto-adjustment of the row height upon a sort.

Hello, I am a Newbie and this is my first post: I create a report log in Excel by exporting the dataq from an Access Database via the MS Query function. Everything works perfect with the exception of applying the Autofit to my worksheet. Because there are two large Memo fields being pulled, all of the text does not displauy--even when I apply Autofit. I have to manually adjust each of the rows to ensure that the text is both displayed on the screen and then printed correctly. If there some VBA Code I could run that would allow me to add "x" amount of points to the Row Height after the Autofit Function was applied?

Thank you,

Using Excel 2003

Below is a simple macro for adjusting the row height for the specified rows. It basically runs to set rows 1 to 57 inclusive to 15.25.

ActiveWindow.SmallScroll Down:=12
Selection.RowHeight = 15.25

but whenever i run the macro i get the following error:

Run error 1004
Unable to set the RowHeight property of the Range Class

the same happens when instead of 'Selection.RowHeight = 15.25' i use 'Selection.EntireRow.Hidden = True'

the error message is
Run error 1004
Unable to set the hidden property of the Range Class

Am i doing something wrong?

In previous versions of Excel, when I did a format/cells/alignment and then
checked the "wrap text" box, the row height of the cell would change if that
was required to display all the text in the box. This doesn't seem to work
for me in Excel 2007. I click on a cell which has a long text string in it,
only a some of which is displayed. Doing a format cells/alignment and then
checking the box for "Wrap text" does *not* change the row height. The cell
remains showing only a porttion of the total text string in it. What am I
doing wrong?


It's just another column.

Put some kind of indicator in that column (Yes/No, True/False, anything that
would indicate what you want to do later.)

Then sort your data (but include that column with the indicator in the range

Now all your rowheights are mixed up. Select all the cells and autofit the

Filter by that helper column so that you only see Yes, True (or whatever).

Select those visible rows and adjust the rowheight (double it???).

Then data|filter|showall
(or remove the filter.)

(Hide or delete the helper column if you don't need it anymore.)

Michelle wrote:
> Hi Dave,
> Thanks for your post. I am having the same problem. Did not have this
> problem with previous version of Excel! Anyway...can you explain more about
> the helper row? I've used Excel for years but never heard of that.
> "Dave Peterson" wrote:
> > The rowheight stays with the row.
> >
> > If I had to do this, I'd add a helper cell per row -- some kind of indicator.
> >
> > then sort my data,
> > autofit all the rows
> > and look for that indicator and adjust the rowheight of those rows.
> >
> > tsysjohn wrote:
> > >
> > > I have set the row heights for the rows in my spreadsheet exactly as I want
> > > them - different rows have different heights. When I sort the spreadsheet,
> > > which I do every day or so, Excel changes some of the row heights. How can I
> > > prevent this?
> >
> > --
> >
> > Dave Peterson
> > >


Dave Peterson

I want to set a minimum row height, but allow autofit for anything that is
greater than that height. Is this possible?

i.e. If i have a cell with one line of text, then I'd like to see the
height as 50, as opposed to what the autofit would normally set it as, say
25. Then for any additional lines, autofit will make more than 50 to fit the


I'm having a fun time with Excel 2000, merged cells and row heights! I have
a worksheet with rows of merged cells that span 14 columns. Text is entered
into these merged cells and it often wraps to multiple lines. When I try to
use the Format -> Row -> Autofit function it simply reduces the row height to
the default 12.75, and most of the text becomes hidden. The same thing
happens when I double click the border around the row number at the left of
the window.

This seems counter-intuitive to me. Is there something I'm missing here or
are merged cells not recognized by the autofit function?




I have a spreadsheet which is a list of varying heights of rows depending on the amount of text. There are about 6 columns and I am using Excel 2002 on Windows XP.

I have set autofit to all of the rows so that when I paste text into a row the row automatically adjusts in height to fit the text.

The problem is that when I sort the data by a different column the row height does not move with the data and the text does not fit. For example row 20 may be 25 points high to fit the data but when the data is re-sorted row 20 is still 25 points high and the data that ends up in this row may be a single line or numerous lines which are then partially hidden.

Is there way to tie the row height to the data so that when sorted they move together?



I have a range named "rngOrders" on an Excel 2003 worksheet. I'm looking for a VBA macro that will set the row heights of the range to autofit (for rows/cells with wrapped text) and also set a minimum row height of 19.5 points for all rows. Any suggestions?


I am trying to create a price list for my business. The problem I am having is that the price lists consist of two columns containing text. In the first column, the text has been wrapped, thereby increasing the row height. In the next column, there is less text, therefore leaving a gap with the text in the above row. How can I make excel have varying row heights?

I spent some time searching the forum and found some helpful suggestions for using the autofit feature for merged cells. But this request is a variation of the of the code to Autofit row heights and column widths and does not involve merged cells.

Basically, I want to set it up so that when the user clicks or arrows over to a cell in column 3, 4 or 5, the row height will expand enough to allow them to read the contents of the cell.

The code I currently have in place is:

    If Target.Column = 3 Then 
    ElseIf Target.Column = 4 Then 
    ElseIf Target.Column = 5 Then 
        Rows.RowHeight = 12.75 
    End If 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This works, insofar as it's doing what I've told it to do. But here are the caveats:

1) When the row is autofitted, it works a little too efficiently and autofits to the maximum height needed for all cells in that row. So if the active cell is C4 and there are 3 lines in that cell, but E4 has 14 lines in its cell, the autofit will be effected for the height needed for E4. But when I'm on cell C4, I only want the row height to increase enough to see the entire contents of C4. Otherwise, I'm seeing a lot of unnecessary whitespace. It seems to me that I should be able to have it determine the maximum height necessary for that particular cell based on the content of the cell and then increase the row height to that amount. I considered and tried pulling the Height and assigning it to a variable that would then be used for adjusting the Row Height, but the height did not adjust. I think that may have been because Height was pulling the actual current height of the row, and not the height if the row were autofitted to the contents of that one cell. But my experience with VBA is weak and there are some significant gaps (or chasms, abyss...) in my understanding, so any explanations would be appreciated.

2) Currently, if the active cell is C4 and I use the arrow keys or mouse to navigate to column B, the row height returns to 12.75. I would like to expand on that and say that if I'm on C4 and I navigate up to C3 without changing columns, row 3 should expand appropriately (which it does) while row 4 returns to the 12.75 row height (which does not happen). That basically keeps it clean, and makes sure that only one row is ever expanded at a time. I tried adding

 Target.Rows.Count = 1 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
But all that did was stop everything from working - no errors, it just didn't autofit any more. Again, I suspect that I just don't fully understand how Rows.Count should be used in this situation.

I've attached an example so that you can see how it is currently set up. Just as background, the file will be used as a checkout document, which is why the rows should generally be set at 12.75 (so you can scroll through and easily determine what has passed, what has failed and what still needs to be done), but it is also acting as documentation, which is why the row heights need to be increased for readability.

Why is it that in the same workbook on some sheets when I copy and paste, the
row heights of the copied cells are applied in the pasted cells, but on other
sheets the copied cells are shrunk down to the alloted height of the
destination cells?

Is there a way to change the row height based on the contents of a cell?

Here's what I've done:

1. I have a worksheet with about 6,000 or so lines, containing data for
over 100 departments.

2. I've created Subtotals, and used Ron DeBruin's code to create separate
worksheets for each department.

3. The subtotals came over to the individual worksheets just fine. Now I
want to change the row height of the rows that contain the subtotals to 25,
so the worksheets are easier to read. Each of the subtotal rows has the word
"Total" included in the entry in column B.

Is there a way to automate this task?



I have copied a old worksheet to a new worksheet, however, for some
reason the row height has enlarged on the new worksheet. I get 5 fewer
rows per page on the new worksheet.

How can I check the row height on the old worksheet and transfer the
same settings to the new worksheet.


Automatic Increase/Decrease in Row Height and Column Width in cells

Dear Forum,

In a particular cell, the contents of the cell keep on continuosly Increasing and Decreasing depending on the values entered in other values...

It becomes quite tedious to Increase/Decrease Row Height and Column Width everytime...

What happens in the column D beginning from D2 to D50 that it gets value by a formula and is not entered explicitly..

Sometimes, the values cannot be seen as some values get hidden in the overlap of cells and after manually changing the row height if the contents are less than it takes away more space..

SO is it possible to Increase decrease values based on the Length (# of characters in each cell)


Why is it that in the same workbook on some sheets when I copy and paste, the
row heights of the copied cells are applied in the pasted cells, but on other
sheets the copied cells are shrunk down to the alloted height of the
destination cells?

I have a macro that does a lot of cutting and pasting, and at the end of it all it pastes everything into another worksheet. That last step is messing me up. Here's the code I'm using to do that bit:
What I want to do is tell it to copy and paste EXACTLY as it's copied, including row height for merged cells and cells with
oversized fonts.  I've got a routine right now that will go through and autosize for the merged cells; it works well, but
runs slowly.  As well, I recently had to add a step to autofit the rest of the lines, as some have a larger font and need to
be taller.  Those autofit routines really bog down my macro, so I'd like to know if there's a way to simply copy a whole
spreadsheet and paste exactly as it's formatted, specifically including row height.  

(BTW, the reason I'm copying and pasting my final sheet is that I need to email it, and my source sheet has cells with more than 255 characters, so if I do an email routine copying the worksheet, it truncates those cells with more than 255 characters. So, my email routine copies a blank worksheet with my Headers and Footers, then copies the data from my source sheet and pastes it into that blank worksheet. It's at that point I have to run my autofit routines. I'd much prefer not to have to run them at all).

I appreciate any help you can provide.

I have a spreadsheet in a workbook. To the right of the spreadsheet is a pivot table summing up all the data on the spreadsheet. The problem is my row heights on the spreadsheet are manually set at 18. However, when I open the workbook, it changes the row heights of the first 10 cells, which are the cells made by the pivot table, making them too small to be able to read the data in the spreadsheet. As the month gets longer and more data for the month is entered into the spreadsheet, the pivot table will get to be much longer and then all the lines on the spreadsheet will be much smaller than I want.

I have tried everything to keep the rows the height of 18, and nothing works. I have been unable to find a person with this 2007 problem online so I would appreciate any help I can get to this problem.

Thanks, JL

No luck finding an answer? You could always try Google.