Rows expand to fit text typed in?

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!
 
D

Dave Peterson

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
 
Top