Columns

[SAW]

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.

 

[Gord Dibben]

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