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

--
Don Guillett
SalesAid Software

"RagDyeR" wrote in message
...
Careful! ... After 5.0 that's been a *Merge* and center icon.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Don Guillett" wrote in message
...
use formatalignmentcenter across. You can add the icon to your toolbars

--
Don Guillett
SalesAid Software

"No Time For Honey Do's" <No Time For Honey

wrote in message
...
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.