How do i center a title across a row

Centering a Title wrote:
How do i center a title across a row

try this demo

http://office.microsoft.com/en-us/ex...CL100570551033

gls858

Select a range of cells A1:F1

FormatCellsAlignmentHorizontalCenter Across Selection.


Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 07:18:02 -0800, Centering a Title <Centering a
wrote:

How do i center a title across a row

gls858 sent you to a demo that shows how to merge cells.

Avoid these like the plague.

They are the source of a great deal of problems when copying, pasting, sorting,
filtering and others.

Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 15:21:01 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Select a range of cells A1:F1

FormatCellsAlignmentHorizontalCenter Across Selection.


Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 07:18:02 -0800, Centering a Title <Centering a
wrote:

How do i center a title across a row

Gord Dibben wrote:
gls858 sent you to a demo that shows how to merge cells.

Avoid these like the plague.

They are the source of a great deal of problems when copying, pasting, sorting,
filtering and others.

Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 15:21:01 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Select a range of cells A1:F1

FormatCellsAlignmentHorizontalCenter Across Selection.


Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 07:18:02 -0800, Centering a Title <Centering a
wrote:

How do i center a title across a row

Thanks for pointing that out Gordon. I took a quick look at at the demo
and it talked about spreading info across three cells. Since I never use
merged cells I always use center across selection as you suggested I just
assumed that was what the demo was showing. My bad for not watching enough
of the demo to determine what it was showing.

gls858

Thanks

I hoped you wouldn't too upset with my pointing out that merged cells can create
havoc.

My mission in life is to get MS to drop the merged cells feature but no luck
yet.

I guess they have their place if the sheet is just for presentation purposes
only but people seem to forget what they have merged and start trying to massage
and run into the problems.


Gord

On Wed, 13 Dec 2006 10:56:03 -0600, gls858 wrote:

Gord Dibben wrote:
gls858 sent you to a demo that shows how to merge cells.

Avoid these like the plague.

They are the source of a great deal of problems when copying, pasting, sorting,
filtering and others.

Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 15:21:01 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Select a range of cells A1:F1

FormatCellsAlignmentHorizontalCenter Across Selection.


Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 07:18:02 -0800, Centering a Title <Centering a
wrote:

How do i center a title across a row

Thanks for pointing that out Gordon. I took a quick look at at the demo
and it talked about spreading info across three cells. Since I never use
merged cells I always use center across selection as you suggested I just
assumed that was what the demo was showing. My bad for not watching enough
of the demo to determine what it was showing.

gls858

Gord Dibben wrote:
Thanks

I hoped you wouldn't too upset with my pointing out that merged cells can create
havoc.

My mission in life is to get MS to drop the merged cells feature but no luck
yet.

I guess they have their place if the sheet is just for presentation purposes
only but people seem to forget what they have merged and start trying to massage
and run into the problems.


Gord

On Wed, 13 Dec 2006 10:56:03 -0600, gls858 wrote:

Gord Dibben wrote:
gls858 sent you to a demo that shows how to merge cells.

Avoid these like the plague.

They are the source of a great deal of problems when copying, pasting, sorting,
filtering and others.

Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 15:21:01 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Select a range of cells A1:F1

FormatCellsAlignmentHorizontalCenter Across Selection.


Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 07:18:02 -0800, Centering a Title <Centering a
wrote:

How do i center a title across a row
Thanks for pointing that out Gordon. I took a quick look at at the demo
and it talked about spreading info across three cells. Since I never use
merged cells I always use center across selection as you suggested I just
assumed that was what the demo was showing. My bad for not watching enough
of the demo to determine what it was showing.

gls858

Don't mind at all. The important thing is that the OP gets their problem
solved without creating any new ones :-)

gls858