Lots of text in one cell

[Robert Crandal]

After I click on File->New, Excel will begin with a default size empty
sheet. If I type a long, say 100+ character, string into cell A1 then
that text will visibly spill over in the adjacent cells.

Is there a way to tell Excel to resize or redimension cell A1 so that
my string completely fills the cell in a nice looking manner??? I
basically want any arbitrary string that I type to completely visible
and contained within cell A1 in a nice looking way.

thank you

 

[Paul Robinson]

Hi
Tricky to do in a consistent, automated and attractive way. Excel
doesn't do attractive on the whole. You would have to get into
character widths I reckon - more trouble than it is worth?
I would just set the column width and turn on text wrapping for that
column (Cell format, alignment, wrap text).
regards
Paul

 

[Mike H]

Hi,

You could do this. Alt+F11 to open VB editor and double click the shet to
which this applies and paste the code below in.

This does the entire sheet but it can be limited to only certain columns

Private Sub Worksheet_Change(ByVal Target As Range)
Target.EntireColumn.AutoFit
End Sub
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Fred]

Try using the Autofit.
Columns("A:A").EntireColumn.AutoFit

Good luck
Fred