ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrap Text Format (https://www.excelbanter.com/excel-discussion-misc-queries/159600-wrap-text-format.html)

bweaverusenet

Wrap Text Format
 
Hi. I've got some wrapped text in Excel 2003. Is there any way to
change the line height of text in a cell, so that there would be less
space between lines? In other words, is there a way to control line-
height, or a trick to fake it?

E.g. If I've got a cell with

red
white
blue

....the wrapped lines have too much space between them and I want to
push them closer together.

Is this possible? Thanks!


Pete_UK

Wrap Text Format
 
Change the font in the cell to a lower size?

Pete

On Sep 25, 7:32 pm, bweaverusenet wrote:
Hi. I've got some wrapped text in Excel 2003. Is there any way to
change the line height of text in a cell, so that there would be less
space between lines? In other words, is there a way to control line-
height, or a trick to fake it?

E.g. If I've got a cell with

red
white
blue

...the wrapped lines have too much space between them and I want to
push them closer together.

Is this possible? Thanks!




bweaverusenet

Wrap Text Format
 
On Sep 25, 3:58 pm, Pete_UK wrote:
Change the font in the cell to a lower size?


In CSS terms, I'm talking about the line-height, not font-size.
Regardless of the font-size I want the lines closer together.

In Word, it's format / paragraph spacing / line-spacing, but I would
like to control that in a wrapped bit of Excel text.

Thanks.


Gord Dibben

Wrap Text Format
 
Interior line-spacing is not possible in Excel.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 20:25:41 -0000, bweaverusenet
wrote:

On Sep 25, 3:58 pm, Pete_UK wrote:
Change the font in the cell to a lower size?


In CSS terms, I'm talking about the line-height, not font-size.
Regardless of the font-size I want the lines closer together.

In Word, it's format / paragraph spacing / line-spacing, but I would
like to control that in a wrapped bit of Excel text.

Thanks.




All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com