Share via

Change default minimum row height

Anonymous
2013-04-11T15:16:37+00:00

I have the rows set to auto-height to accept wrap text. But the default height is 11.25 due to text size. I need to keep all the various text sizes, but do not want any rows less than 15.00 in height (Still allowing larger heights for wrapped text).

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2014-07-24T10:53:49+00:00

You can do this with Macros.

  1. Press Alt+F11
  2. Click on the sheet on the left to which you want to make this adjustment (Say Sheet4)
  3. On the right (editor window), at the top you see General written and a drop down.
  4. Select the drop down to "Worksheet". In the next drop down, select "Change".
  5. Paste the code below in the editor window.

Private Sub Worksheet_Change(ByVal Target As Range)

Set Target = ActiveCell

Cells.RowHeight = 15

End Sub

  1. Save the file

There you go!

Thanks

Avnav

Was this answer helpful?

30+ people found this answer helpful.
0 comments

21 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-04-15T10:41:17+00:00

    Your method is correct. The problem is when I select the entire sheet and format to "Auto-Height", it then reduces the row height back to 11.25. I was hoping for an option to restrict height to no less than 15.00 in height. No matter what is done with formatting.

    Was this answer helpful?

    9 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-04-16T15:51:30+00:00

    Pasted in Module, nothing happened?? I know this is lazy, but I increased font in new A-column and hid it. It works, but only as long as no-one messes with that hid column.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments
  3. Anonymous
    2015-07-29T01:53:51+00:00

    So, the default row-height in excel 14.0.7.....

    12.75

    When I change that to 15 as per above outlined method...

    Then selecting Format - autofit row height -> causes it to revert back to 12.75

     ....And doing it the other way around you lose the 'autofit'.

    Hence this does not change the default row-height, it just changes the current row-height. 

    What I'm trying to achieve: 

    Basic formatting such that 1 text line height becomes say 15, so 2 text lines in a box and height by default becomes 2x15=30, 3 lines 45, etc.

    Reasons for me needing to be able to change the default row height:

    Hundreds of lines & still modifying content in a 'living document'.

    I.e. it needs to be able to be formatted and easily modified, without affecting such formatting.

    The current answers do not allow for this, nor have I been able to find another way in Excel.

    Perhaps Microsoft would be so kind as to allow us to set that value somewhere, from within Excel itself?

    (I assume there's an "ini" type file somewhere already where it's currently configured, but as an external contractor I'm not about to go mess with such settings)

    Many thanks

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  4. Anonymous
    2013-04-12T05:32:23+00:00

    Hi Sean,

    As I understand you want to set the row height not less than 15 in Excel. Correct me if I am wrong.

    Let me assist you with the issue:

    To set row height in Excel, select the complete sheet (Ctrl+A), click on Format in Cells group under Home tab and select Row Height. Set the row height to 15 and click Ok.

    If you want the text to auto fit in the row as you type then select the complete sheet (Ctrl+A), click on Format in Cells group under Home tab and select AutoFit Row height.

    You may also refer to the link mentioned which explains about Wrapping text in a cell:

    http://office.microsoft.com/en-us/excel-help/wrap-text-in-a-cell-HP010343041.aspx

    I hope this fixes the issue. Let us know if you need any further assistance.

    Thank you.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments