Rows expand to fit text typed in?
 

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!

Rows expand to fit text typed in?
 

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


Amy wrote:

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!

--

Dave Peterson

Rows expand to fit text typed in?
 

If the cells are "merged" autofit won't happen.........even with Dave's
event code.

If that is the case......................

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Mon, 28 Jul 2008 12:48:25 -0700, Amy
wrote:

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!