View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.