Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top