You don't.

Column width and row height are properties of the entire column and row.

A few workarounds........cut the bottom-half data to a new worksheet and format
the column widths as you wish then take a picture............. SHIFT + EditCopy
Picture and paste into the original worksheet.

Get rid of gridline view and use borders to outline groups or cells.

Merge cells..........not a great idea because of the problems these can cause.

Use Center Across Selection fro FormatCellsAlignment


Gord Dibben MS Excel MVP


On Tue, 5 Jun 2007 19:30:01 -0700, SAW wrote:

I am making up a form in Excel and I have a column that is split. I want to
make the upper column one width and the lower one another width. How do I do
that? Thanks.