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

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


"Ravi" wrote in message
...

FormatCellsAlignment and Center Across Selection in the Horizontal box.

--

HTH

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


"Ravi" wrote in message
...

Select the range of cells in question

Right-Click Format Cell

Alignment Tab "Horizontal" dropdown

Choose: "Center Across Selection"

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.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Anne Troy" wrote in message
news:5d9b8$42c2e954$97c5108d$14895@allthenewsgroup s.com...
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


"Ravi" wrote in message
...