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

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
 
S

Stefi

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:
 

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

Row Height Auto Fit & Vlookup 3
Shrink to fit Macro Button 3
Resizing cells to fit text returned by VLOOKUP 10
How to have a cell auto resize the font to make text fit in cell? 1
expand row to fit 1
Format cell to both Wrap text and shrink to fit 1
shrink to fit problem 1
Shrink the Text 1

Top