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

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