Center across selection

  • Thread starter Thread starter gcotterl
  • Start date Start date
G

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?
 
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?
Click to expand...

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.
 
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
 
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 -
Click to expand...

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