#1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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!

  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 high cpu usage, format cell, wrap text Michael S. Wall Excel Discussion (Misc queries) 9 October 16th 09 07:34 PM
Can not see text in Excel when cell format is set to wrap text Mark New Users to Excel 1 May 29th 07 02:07 PM
Activating wrap text format causes my text to disappear, why? Oli Excel Discussion (Misc queries) 2 March 5th 07 10:46 PM
Why won't text in cell wrap. Cell format set to wrap. DRB Excel Discussion (Misc queries) 2 September 28th 06 08:27 PM
Problem with wrap text format Mitch Excel Worksheet Functions 1 January 20th 05 09:46 AM


All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"