Different Column Widths on a Single Worksheet (more complicated than it sounds)

Question

Different Column Widths on a Single Worksheet (more complicated than it sounds)

Anonymous

Hi,

I'm trying to have 2 tables on a single worksheet, 1 above the other, but the tables need different column width. I've tried to merge cells to make the lower table correct but it's not right and my OCD brain is struggling with it.

Is there a way to have 2 different column widths in a single worksheet? For example, column D would have a width of 7 for rows 1 - 20 (the first table) and a width of 13 for rows 21 onwards? I was thinking about some sort of page break type function (but only guessing).

I need the tables in Excel due to the formulas, linked cells and on the same worksheet due to the subject matter (and to avoid multiple worksheets).

Any ideas?

Cheers,

AB

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Hi,

An Excel worksheet is 2 dimensional and can only have a single width or height for a single column or row. You have 2 choices.

Display the tables side by side.
Use the selection change event to alter the column width dependent upon which table the active cell is in.

Merging cells is something I would avoid at all costs, merged cells are a menace.

Share via

Different Column Widths on a Single Worksheet (more complicated than it sounds)

0 additional answers