Centering text on a page

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

Is there a way to center text automatically in a row across the top of the
page without having to pick a column that is close to center, then using the
space bar to find the exact midpoint?

Thnxs
 
Hi Justin!

Select the cells across your page
Format > Cells > Alignment
Place check in "Merge cells"
Horizontal and Vertical drop downs should be set at Center
OK

There is a standard toolbar button for this. Use:

View > Toolbars > Customize
Look under Format for the Merge and Center button
Click and drag it to your toolbar.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Using this avoids the problems with using merge cells.

Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
 
I *can not* believe that someone is *recommending* the use of "Merge Cells"
!
--

Regards,

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

Is there a way to center text automatically in a row across the top of the
page without having to pick a column that is close to center, then using the
space bar to find the exact midpoint?

Thnxs
 
Hi!

Point taken! Must have been very late down here.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top