resizing a range of cells
 

I need several tables on a single sheet. Each table has different fields, so
I need different sizes of cells. How do I do this? Thank you.

resizing a range of cells
 

Put your tables adjacent to each other under different columns.

ckane wrote:

I need several tables on a single sheet. Each table has different fields, so
I need different sizes of cells. How do I do this? Thank you.

resizing a range of cells
 

Some of the tables need to be below others.

"Bob I" wrote:

Put your tables adjacent to each other under different columns.

ckane wrote:

I need several tables on a single sheet. Each table has different fields, so
I need different sizes of cells. How do I do this? Thank you.

resizing a range of cells
 

Then you will have to make do with merged cells in the odd ones.

ckane wrote:

Some of the tables need to be below others.

"Bob I" wrote:


Put your tables adjacent to each other under different columns.

ckane wrote:


I need several tables on a single sheet. Each table has different fields, so
I need different sizes of cells. How do I do this? Thank you.

resizing a range of cells
 

Cell sizes are a function of column width and row height.

Both these are a property of the ENTIRE row and column.

Maybe "center across selection" from FormatCellsAlignmentHorizontal could
work for you.

I hesitate to to suggest this, but you could use the "merge cells" feature.

The hesitation comes from all the problems that merged cells can cause with
sorting, filtering, copying, pasting and others.


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 09:02:01 -0700, ckane
wrote:

Some of the tables need to be below others.

"Bob I" wrote:

Put your tables adjacent to each other under different columns.

ckane wrote:

I need several tables on a single sheet. Each table has different fields, so
I need different sizes of cells. How do I do this? Thank you.