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