How to center a title across a range of cells in Excel ?

[Anne Troy]

Ravi: On the formatting toolbar there's a button that looks something like
this: <-A-> Select your cells and HIT IT!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Bob Phillips]

Format>Cells>Alignment and Center Across Selection in the Horizontal box.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[JustinLabenne]

Select the range of cells in question >

Right-Click > Format Cell >

Alignment Tab > "Horizontal" dropdown >

Choose: "Center Across Selection"

 

[Earl Kiosterud]

Anne,

The button you describe is the Merge and Center button, and is considered
more trouble than it's worth. You have trouble with selections, pasting,
getting seeds out of your teeth -- all kinds of stuff, which shows up later
long after you've forgotten you even used merge and center. Better is Bob's
suggestion of Format - Cells - Alignment - Center across selection. You
select the cells (that you'd have merged), then use that command. Put the
stuff you want to appear in the selected range into the leftmost cell.