How do I expand/stretch one cell in an Excel workshet.

  • Thread starter No Time For Honey Do's
  • Start date
N

No Time For Honey Do's

I typed some text underneath the title of my worksheet. I want to be able to
view all of this text at one time. For some reason I cannot seem to be able
to do that.

I want to make A2 stretch across the page so all the text will show up. The
text doesn't even show up in Print Preview.
 
D

Don Guillett

I guess I'm just so used to mine that I forgot that I have this in my
personal.xls and have a custom button assigned to it.

Sub CenterAcrossOld()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
 
Top