SOLVED

Is it possible (without coding) to automatically modify the row height in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-2538675%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20(without%20coding)%20to%20automatically%20modify%20the%20row%20height%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2538675%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20see%20if%20it%20is%20possible%20to%20automatically%20get%20Excel%20to%20adjust%20the%20row%20hieght%20in%20cells%20depending%20on%20the%20text%20that%20is%20in%20it.%3C%2FP%3E%3CP%3EThe%20issue%20I%20have%20is%20that%20if%20a%20cell%20has%20a%20lot%20of%20text%20in%20it%20the%20text%20rolls%20off%20the%20bottom%20and%20is%20not%20visible.%3C%2FP%3E%3CP%3EI%20Know%20you%20can%20manually%20click%20to%20expand%20the%20row%20height%2C%20but%20is%20it%20possible%20for%20something%20to%20be%20set%20to%20adjust%20automatically%20%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2538675%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2539211%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20(without%20coding)%20to%20automatically%20modify%20the%20row%20height%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2539211%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1101455%22%20target%3D%22_blank%22%3E%40GlenRowson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20apply%20%3CSTRONG%3EWrap%20text%3C%2FSTRONG%3E%20is%20shall%20work%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2539375%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20(without%20coding)%20to%20automatically%20modify%20the%20row%20height%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2539375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1101455%22%20target%3D%22_blank%22%3E%40GlenRowson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAs%20Mr.%20Baklan%20already%20informed%20you%2C%20with%20wrap%20text%20you%20can%20manage%20the%20line%20break.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20additional%20information%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMicrosoft%20Link%3A%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwrap-text-in-a-cell-2a18cff5-ccc1-4bce-95e4-f0d4f3ff4e84%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EWrap%20text%20in%20a%20cell%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EVBA%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESub%20wrap()%0A%20%20With%20Range(%22B9%22)%0A%20%20%20%20.Value%20%3D%20Replace(.Value%2C%20%22%3B%22%2C%20vbLf)%0A%20%20%20%20.Value%20%3D%20Replace(.Value%2C%20vbLf%20%26amp%3B%20%22%20%22%2C%20vbLf)%0A%20%20%20%20.EntireRow.AutoFit%0A%20%20End%20With%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%20C1N51c%22%3EIn%20composite%20cells%20it%20is%20not%20possible%20to%20have%20the%20row%20height%20or%20width%20determined%20automatically.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%20C1N51c%22%3EIf%20you%20want%20to%20wrap%20text%20in%20merged%20cells%2C%20you%20have%20to%20do%20it%20differently.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%20C1N51c%22%3EIf%20so%2C%20please%20let%20me%20know%20to%20show%20the%20way.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2541690%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20(without%20coding)%20to%20automatically%20modify%20the%20row%20height%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2541690%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B-%20Many%20thanks%20for%20getting%20back%20to%20me%20with%20this%20advice%20-%20I%20really%20appreciate%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2541691%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20(without%20coding)%20to%20automatically%20modify%20the%20row%20height%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2541691%22%20slang%3D%22en-US%22%3EMany%20thanks%20for%20getting%20back%20to%20me%20with%20this%20advice%20-%20I%20really%20appreciate%20it.%3C%2FLINGO-BODY%3E
New Contributor

I am looking to see if it is possible to automatically get Excel to adjust the row hieght in cells depending on the text that is in it.

The issue I have is that if a cell has a lot of text in it the text rolls off the bottom and is not visible.

I Know you can manually click to expand the row height, but is it possible for something to be set to adjust automatically ?

Thanks

 

Glen

5 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@GlenRowson 

If apply Wrap text is shall work

@GlenRowson 

As Mr. Baklan already informed you, with wrap text you can manage the line break.

 

Here is additional information:

Microsoft Link: Wrap text in a cell

 

VBA:

 

Sub wrap()
  With Range("B9")
    .Value = Replace(.Value, ";", vbLf)
    .Value = Replace(.Value, vbLf & " ", vbLf)
    .EntireRow.AutoFit
  End With
End Sub

 

 

In composite cells it is not possible to have the row height or width determined automatically.

If you want to wrap text in merged cells, you have to do it differently.

If so, please let me know to show the way.

 

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE - Many thanks for getting back to me with this advice - I really appreciate it.

Many thanks for getting back to me with this advice - I really appreciate it.

@GlenRowson 

I am pleased that you have received the proposed solution from MR. Baklan helped.

I added only the steps.

 

I wish you continued success with Excel.