| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i print workbook text after resizing cells to fit text | Excel Discussion (Misc queries) | |||
| Resizing cells in a selection without resizing entire sheet | Excel Discussion (Misc queries) | |||
| Resizing cells | Excel Discussion (Misc queries) | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
| Resizing cells when importing data from the clipboard | Excel Discussion (Misc queries) | |||
Hybrid Mode
