Rows expand to fit text typed in?

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

Hi - I have my cells set up to wrap text. However, even with that, the row
height (which is not set to fixed height), does not expand to fit the text
typed in. Is there a way in which I can get to "auto-expand" to fit whatever
is typed into the row without just setting a really big fixed height? Thank
you!
 
You could use an event macro.

Rightclick on the worksheet tab that should have this behavior, select view code
and paste this into the code window.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Target.EntireRow.AutoFit
End Sub
 
Back
Top