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?

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 -

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Firefox Multi-Account Containers 1
Happy Birthday V_R 3
Happy Birthday Ian 4
Happy Birthday @Ian 7
Happy Birthday Ian 11
Happy Birthday @floppybootstomp 7
Happy Birthday @muckshifter 4
Happy Birthday nivrip 9

Back
Top