View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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