set height of individual cells
 

I have 4 adjacent cells, say A thru D.
Cell A contains text, is set to wrap and has 4 lines within it.
Cells B - D each contain one data number.
The wrapping setting of cell A, increases not only its height, but increases
the height of the whole row.
Is there any way of reducing the height of cells B - D for the "single line"
height of the data numbers, but retain the increased height of cell A?
Given the infinite flexibility of Excel, this must be possible, but it beats
me.
Help please.

--
donwb

set height of individual cells
 

The easiest way is to merge cells vertically. Say select cells A1 and A2 and
pull-down:

Format Cells... Alignment and check Merge
--
Gary's Student


"donbowyer" wrote:

I have 4 adjacent cells, say A thru D.
Cell A contains text, is set to wrap and has 4 lines within it.
Cells B - D each contain one data number.
The wrapping setting of cell A, increases not only its height, but increases
the height of the whole row.
Is there any way of reducing the height of cells B - D for the "single line"
height of the data numbers, but retain the increased height of cell A?
Given the infinite flexibility of Excel, this must be possible, but it beats
me.
Help please.

--
donwb

set height of individual cells
 

Why do you need this? You can only set a row height, not have various cell
heights in one row, it would be horrendously confusing at least.If it is
because you want all cells to display at the same first line level, then set
you vertical text alignment to Top.
Normal Display = asdf
qwerty asdf

If set to top = asdf asdf
qwerty

"donbowyer" wrote:

I have 4 adjacent cells, say A thru D.
Cell A contains text, is set to wrap and has 4 lines within it.
Cells B - D each contain one data number.
The wrapping setting of cell A, increases not only its height, but increases
the height of the whole row.
Is there any way of reducing the height of cells B - D for the "single line"
height of the data numbers, but retain the increased height of cell A?
Given the infinite flexibility of Excel, this must be possible, but it beats
me.
Help please.

--
donwb

set height of individual cells
 

True - but putting all the vertical alignment at the top achieves what I need.
Thanks to all who responded
--
donwb


"kassie" wrote:

Why do you need this? You can only set a row height, not have various cell
heights in one row, it would be horrendously confusing at least.If it is
because you want all cells to display at the same first line level, then set
you vertical text alignment to Top.
Normal Display = asdf
qwerty asdf

If set to top = asdf asdf
qwerty

"donbowyer" wrote:

I have 4 adjacent cells, say A thru D.
Cell A contains text, is set to wrap and has 4 lines within it.
Cells B - D each contain one data number.
The wrapping setting of cell A, increases not only its height, but increases
the height of the whole row.
Is there any way of reducing the height of cells B - D for the "single line"
height of the data numbers, but retain the increased height of cell A?
Given the infinite flexibility of Excel, this must be possible, but it beats
me.
Help please.

--
donwb