Columns

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.

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 + Edit>Copy
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 Format>Cells>Alignment


Gord Dibben MS Excel MVP


On Tue, 5 Jun 2007 19:30:01 -0700, SAW <SAW@discussions.microsoft.com> 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.