ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   line spacing in wrapped cell (https://www.excelbanter.com/excel-discussion-misc-queries/213744-line-spacing-wrapped-cell.html)

carterb3

line spacing in wrapped cell
 
How can I bring 2 lines of wrapped text in a single cell closer together? I
would like to reduce the line spacing between the 2 wrapped lines that are in
a single cell.

Jonathan Cooper

line spacing in wrapped cell
 
If you mean, you still want the text to wrap, it's jus that the blank space
inbetween the rows needs to be smaller, try a different font.

"carterb3" wrote:

How can I bring 2 lines of wrapped text in a single cell closer together? I
would like to reduce the line spacing between the 2 wrapped lines that are in
a single cell.


carterb3

line spacing in wrapped cell
 
Thanks Jonathan. Problem is, I need to print 2 or 3 lines of text within .25"
high space. I am using 8 point Arial (the smallest I have on my PC), and I
have wrap turned on for the cell. The space between the 1st line and the 2nd
line of the wrapped text seems huge and I would like to reduce it almost to
the point where the bottom of the 1st line letters touches the top of the 2nd
line letters, the same for the 2nd line and 3rd line. Is this possible?

"Jonathan Cooper" wrote:

If you mean, you still want the text to wrap, it's jus that the blank space
inbetween the rows needs to be smaller, try a different font.

"carterb3" wrote:

How can I bring 2 lines of wrapped text in a single cell closer together? I
would like to reduce the line spacing between the 2 wrapped lines that are in
a single cell.


Gord Dibben

line spacing in wrapped cell
 
You can use less than 8 pt Arial

Simply type the number into the Font Size where it says "Size"

You can go as low as 1.....................limits are 1 to 409

Very unreadable if two or three lines in a .25 inch row height.


Gord Dibben MS Excel MVP


On Tue, 16 Dec 2008 11:40:02 -0800, carterb3
wrote:

Thanks Jonathan. Problem is, I need to print 2 or 3 lines of text within .25"
high space. I am using 8 point Arial (the smallest I have on my PC), and I
have wrap turned on for the cell. The space between the 1st line and the 2nd
line of the wrapped text seems huge and I would like to reduce it almost to
the point where the bottom of the 1st line letters touches the top of the 2nd
line letters, the same for the 2nd line and 3rd line. Is this possible?

"Jonathan Cooper" wrote:

If you mean, you still want the text to wrap, it's jus that the blank space
inbetween the rows needs to be smaller, try a different font.

"carterb3" wrote:

How can I bring 2 lines of wrapped text in a single cell closer together? I
would like to reduce the line spacing between the 2 wrapped lines that are in
a single cell.




All times are GMT +1. The time now is 03:06 AM.

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