Column width and row height are properties of the column and row and cannot be
changed for sections of a sheet.
Can you employ the "center across selection" formatting found in
FormatCellsAlignmentHorizontal?
The only other outlet you have is to "merge" some cells.
I don't recommend this due to problems with sorting, copying, filtering and
other operations when using merged cells.
Gord Dibben Excel MVP
On Mon, 24 Oct 2005 13:18:10 -0700, "Excel dummy" <Excel
wrote:
I am trying to format a chart in excel, but I have some other information in
the document that I do not want formatted the same way. How can I apply
special formatting to one part of the document, but not the other.
Specifically, I would like to adjust the width of columns for some of the
document, but not for the other part of the document. Thanks