Center across selection

[gcotterl]

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?

 

[GS]

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 Copy>Insert Copied Cells on a preselected column that's formatted
to your liking.

 

[Gord Dibben]

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

 

[gcotterl]

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





- 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.

 

[Gord Dibben]

Clumsy but works.


Thanks for the feedback, Gord