Changing line height within a cell ?

[Blue Max]

How do we change the line height (not row height) between multiple lines
that wrap within one cell? For example, we have two-line labels in a header
row and want the words on separate lines within the cell to be closer to
each other. Isn't there a way to change the line height between lines of
text?

 

[Pete_UK]

A very similar question was asked a few days ago - the answer is no.
Excel does not have the same capabilities on line spacing that a word
processor like Word has. All you can do is adjust the font within
those header cells to get different line spacings (and larger/smaller
text at the same time).

An alternative would be to have two rows for the headers, and then you
could adjust the row height of the second row.

Hope this helps.

Pete

 

[Jim Rech]

All you can do is adjust the font within

There is also "distributed" vertical text alignment. Not helpful here
though since it seems to make spacing larger then normal but not smaller.
--
Jim
A very similar question was asked a few days ago - the answer is no.
Excel does not have the same capabilities on line spacing that a word
processor like Word has. All you can do is adjust the font within
those header cells to get different line spacings (and larger/smaller
text at the same time).

An alternative would be to have two rows for the headers, and then you
could adjust the row height of the second row.

Hope this helps.

Pete

 

[Blue Max]

Thank you for the information, Pete. A pity this feature is missing since
the default spacing in the default row height often provides poor visual
cohesion between the related words of the heading compared to the margin
spacing between the text and cell boundaries.

***************
A very similar question was asked a few days ago - the answer is no.
Excel does not have the same capabilities on line spacing that a word
processor like Word has. All you can do is adjust the font within
those header cells to get different line spacings (and larger/smaller
text at the same time).

An alternative would be to have two rows for the headers, and then you
could adjust the row height of the second row.

Hope this helps.

Pete