A heading is centered across columns A and B.

When I insert column C, the heading becomes centered across columns A,
B and C.

How do can I get the heading to be centered across columns A and B?

gcotterl submitted this idea :
A heading is centered across columns A and B.

When I insert column C, the heading becomes centered across columns A,
B and C.

How do can I get the heading to be centered across columns A and B?

When you insert columns, the new column takes the format of the column
to the left of your insertion point. Thus, Center Across Selection
extended into the new column. If you don't want this to happen then use
the popup format menu that appears to configure formatting,

OR...

use CopyInsert Copied Cells on a preselected column that's formatted
to your liking.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Select the 3 columns and re-format to general.

Select A and B and re-format as center across.

A pain in the ass but you can't re-train Excel to stop the problem of adding the
inserted colulmn to the mix.

Alternate method.

With A and B centered across.

Select any blank column(E for instance)and copy it.

Select C1 and "Insert copied cells"


Gord Dibben MS Excel MVP

On Sat, 15 Jan 2011 10:22:49 -0800 (PST), gcotterl
wrote:

A heading is centered across columns A and B.

When I insert column C, the heading becomes centered across columns A,
B and C.

How do can I get the heading to be centered across columns A and B?

On Jan 15, 2:05*pm, Gord Dibben wrote:
Select the 3 columns and re-format to general.

Select A and B and re-format as center across.

A pain in the ass but you can't re-train Excel to stop the problem of adding the
inserted colulmn to the mix.

Alternate method.

With A and B centered across.

Select any blank column(E for instance)and copy it.

Select C1 and "Insert copied cells"

Gord Dibben * * MS Excel MVP

On Sat, 15 Jan 2011 10:22:49 -0800 (PST), gcotterl
wrote:



A heading is centered across columns A and B.

When I insert column C, the heading becomes centered across columns A,
B and C.

How do can I get the heading to be centered across columns A and B?- Hide quoted text -

- Show quoted text -

Your "Select the 3 columns and re-format to general" and "Select A and
B and re-format as center across" suggesions work perfectly

Thanks.

Clumsy but works.


Thanks for the feedback, Gord

On Sat, 15 Jan 2011 16:12:05 -0800 (PST), gcotterl
wrote:

Your "Select the 3 columns and re-format to general" and "Select A and
B and re-format as center across" suggesions work perfectly