MS-Excel Cell Width

[damini_dd]

Hello Friends,

I want to design an excel sheet in such a way that in the same worksheet first half of the sheet has different column width than rest half. Is it possible.

My problem is that I want to design a spread sheet in which
first row is single cell which i can do using merge.

second half has 7 columns with different column width.

and in third half of the sheet i want 8 columns of different width.

thanks in advance

[PrntRhd]

Moved from PC World to Applications forum, a better forum for asking for assistance.

[Cavalier90]

Just where are these three halves going? Are they split by columns or by rows? Columns is easy to do, rows is harder.

[Paul Komski]

If you want 7 columns of equal width in the top half and 8 columns of equal width in the bottom half and you want the width of the 7 columns to equal the width of the 8 columns then the only way I can think of for doing this is to embed one xls file inside another one.

Setup your workbook with 7 columns and create another xls file with 8 columns containing the data you want to dispay in the first workbook and save to disk. In the first notebook from insert choose object and then Create from File and then Browse to the saved 8 column workbook and ensure you check the box to link both files and click OK. Resize appropriately.

This is a rather messy way to go so why not first setup 8 columns and just merge the adjacent cells in two columns to make those rows have seven columns.