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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell does not expand to fit text 1
Auto fit row height for one column 3
Need help on formatting row height 1
Auto fit contents 1
Automate row height to fit text 3
Row Height - Auto-Fit 1
Making row automatically expand as text is typed. 2
Format cell to both Wrap text and shrink to fit 1

Top