How to set a cell to expand to fit text in Excel not shrink fit

  • Thread starter Thread starter Elisal
  • Start date Start date
E

Elisal

I'm not sure it this is doable but is it possible to set a cell so that it
automatically displays all the text that is in there, expanding where
necessary without manual changes.

i don't want shrink to fit as I need to text to be of a certain size
 
Wrapping text can be one way or install such an event sub:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then Columns(Target.Column).AutoFit
End Sub

This works on column A!

Post if you need help to install it!

--
Regards!
Stefi



„Elisal†ezt írta:
 
Back
Top