How to have cells automatically expand when typing

[Guest]

Is there a way to have the cells automatically increase row height when what
you are typing is exceeds the cell dimensions? I have to describe entries in
a cell and the column width is good, I don't want that to change but I would
like the row height to automatically change so I can see all the text.

 

[Dave Peterson]

You could use an event macro that autofits the changed cell's row height
whenever you make a change.

If you want to try, 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

But be aware that most macros destroy the Edit|Undo and Edit|Redo stack. (I'd
just do it manually so I wouldn't lose that.)

 

[Guest]

Have you also tried: format >> row>>autofit?

 

[Guest]

Thank you both, simple for me is best. What I did is checked wrap text under
format cells --> alignment tab. Autoformat did not work and the macro sounded
a bit iffy.
Thanks again