Excel 2007 Is it possible to vary the column width between rows?

R

Reggie Kemp

Excel 2007 Is it possible to vary the column width between rows? Can column
C be made to be 12 characters wide in rows 10-20 and 18 wide in rows 21-25?

I am trying to create a form with a block 12 columns wide and 10 rows at the
top. Under that are two blocks of information that require widely different
column widths, but mus fit in the same 8.5 x 11 sheet size. No calculations
are performed in the two bottom blocks of data. They are merely data entry
blocks.
 
S

Sheeloo

No, it can not be done.

You can however merge the cells in row 21-25 with the next column and adjust
the width...
 
S

Shane Devenshire

Hi,

can't be done in any version of Excel. Nor can row heights vary along a
single row.

If you want those kind of features you can work with a Word table.
 
S

Stephen Bye

You can use Merged Cells to achieve a similar effect.

For example. set the column widths to 6 characters, then to get cells 12
characters wide you can merge 2 adjacent cells, and to get cells 18
characters wide you can merge 3 adjacent cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top