Can we change line spacing in Excel? (Not row height.)

[StargateFanFromWork]

If the text is too widely spaced apart between sentences in a cell, is there
a way we can scrunch them closer together similar to what we can do in a
word-processing program when we change line height? Tx. :oD

[Bucky]

StargateFanFromWork wrote:
> If the text is too widely spaced apart between sentences in a cell, is there
> a way we can scrunch them closer together similar to what we can do in a
> word-processing program when we change line height? Tx. :oD

I think you mean character (horizontal) spacing, not line (vertical)
spacing. I don't think you can do that with Excel. But you can choose
Arial Narrow font, which has the same height but narrowing. Or you can
just choose a smaller font size too.

[StargateFanFromWork]

"Bucky" <uw_badgers@email.com> wrote in message
news:1132696668.110679.156690@g43g2000cwa.googlegroups.com...
> StargateFanFromWork wrote:
> > If the text is too widely spaced apart between sentences in a cell, is
there
> > a way we can scrunch them closer together similar to what we can do in a
> > word-processing program when we change line height? Tx. :oD
>
> I think you mean character (horizontal) spacing, not line (vertical)
> spacing. I don't think you can do that with Excel. But you can choose
> Arial Narrow font, which has the same height but narrowing. Or you can
> just choose a smaller font size too.

Darn. Been there- done that. I'm down to the smallest font I can go
without getting out a loupe! <g> Yet if the lines were closer together
(and, yes, it is called line spacing in a word-processing program <g>)
everything would fit. There's a lot of blank space between the lines that
is being wasted that if we could eliminate would allow everything to fit.
Ah well.

So, in other words, nope. Can't fix line spacing. Darn. Well, we'll just
have to live with it until I can come up with a better solution. There's
nothing in the data left to pare yet the dimensions of the printed form are
set. Nothing we can do about that, either.

Thanks just the same.

[Gord Dibben]

Excel has no cell internal line spacing feature.

How did they become too widely spaced apart?

Only way I can do this is to type a line of text then hit ALT + ENTER a couple
of times then type another line of text or pad between with a bunch of
<spaces> and turn on text-wrap.

If <spaces> try the TRIM function to remove them

If ALT + ENTERs turn off text-wrap to see if there are square boxes between
lines.

If so, edit>replace

what: ALT + 0010

with: <space> or nothing


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 16:44:43 -0500, "StargateFanFromWork"
<noSpam@NoJunkMail.com> wrote:

>If the text is too widely spaced apart between sentences in a cell, is there
>a way we can scrunch them closer together similar to what we can do in a
>word-processing program when we change line height? Tx. :oD
>

[StargateFanFromWork]

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:7r57o19kolofst9ib55k496ud24pju65og@4ax.com...
> Excel has no cell internal line spacing feature.
>
> How did they become too widely spaced apart?

The text is so small now that the usu. spacing in between is the same width,
that's all. There's enough room in between the lines that if we could
affect line spacing, as in a word-processor, 2 lines of text would fit in
these cell dimensions just fine. The row height is set and can't be
modified, you see, to get all the other info in correctly. Yet some of the
text is too long and fits on 2 lines instead of one.

You guys obviously don't have such a wide diversity of stuff to do as I do
in Excel, or you'd have seen this happen before <lol>.

Thanks anyway. Without being able to change line spacing, there is no
solution to the problem as it stands now.

Thanks. :oD

> Only way I can do this is to type a line of text then hit ALT + ENTER a
couple
> of times then type another line of text or pad between with a bunch of
> <spaces> and turn on text-wrap.
>
> If <spaces> try the TRIM function to remove them
>
> If ALT + ENTERs turn off text-wrap to see if there are square boxes
between
> lines.
>
> If so, edit>replace
>
> what: ALT + 0010
>
> with: <space> or nothing
>
>
> Gord Dibben Excel MVP
>
> On Tue, 22 Nov 2005 16:44:43 -0500, "StargateFanFromWork"
> <noSpam@NoJunkMail.com> wrote:
>
> >If the text is too widely spaced apart between sentences in a cell, is
there
> >a way we can scrunch them closer together similar to what we can do in a
> >word-processing program when we change line height? Tx. :oD
> >
>

[Gord Dibben]

One more try........

Maybe the cell is formatted to Vertical>Justify with the row height too tall
which would create spaces between lines.

Turn that off.

BTW........us guys don't normally use Excel as a Word Processor so yes, we
don't run into this sort of issue regularly.


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 17:25:24 -0500, "StargateFanFromWork"
<noSpam@NoJunkMail.com> wrote:

>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:7r57o19kolofst9ib55k496ud24pju65og@4ax.com...
>> Excel has no cell internal line spacing feature.
>>
>> How did they become too widely spaced apart?
>
>The text is so small now that the usu. spacing in between is the same width,
>that's all. There's enough room in between the lines that if we could
>affect line spacing, as in a word-processor, 2 lines of text would fit in
>these cell dimensions just fine. The row height is set and can't be
>modified, you see, to get all the other info in correctly. Yet some of the
>text is too long and fits on 2 lines instead of one.
>
>You guys obviously don't have such a wide diversity of stuff to do as I do
>in Excel, or you'd have seen this happen before <lol>.
>
>Thanks anyway. Without being able to change line spacing, there is no
>solution to the problem as it stands now.
>
>Thanks. :oD
>
>> Only way I can do this is to type a line of text then hit ALT + ENTER a
>couple
>> of times then type another line of text or pad between with a bunch of
>> <spaces> and turn on text-wrap.
>>
>> If <spaces> try the TRIM function to remove them
>>
>> If ALT + ENTERs turn off text-wrap to see if there are square boxes
>between
>> lines.
>>
>> If so, edit>replace
>>
>> what: ALT + 0010
>>
>> with: <space> or nothing
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Tue, 22 Nov 2005 16:44:43 -0500, "StargateFanFromWork"
>> <noSpam@NoJunkMail.com> wrote:
>>
>> >If the text is too widely spaced apart between sentences in a cell, is
>there
>> >a way we can scrunch them closer together similar to what we can do in a
>> >word-processing program when we change line height? Tx. :oD
>> >
>>
>

[Bill Sharpe]

StargateFanFromWork wrote:
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:7r57o19kolofst9ib55k496ud24pju65og@4ax.com...
>> Excel has no cell internal line spacing feature.
>>
>> How did they become too widely spaced apart?
>
> The text is so small now that the usu. spacing in between is the same width,
> that's all. There's enough room in between the lines that if we could
> affect line spacing, as in a word-processor, 2 lines of text would fit in
> these cell dimensions just fine. The row height is set and can't be
> modified, you see, to get all the other info in correctly. Yet some of the
> text is too long and fits on 2 lines instead of one.
>
> You guys obviously don't have such a wide diversity of stuff to do as I do
> in Excel, or you'd have seen this happen before <lol>.
>
> Thanks anyway. Without being able to change line spacing, there is no
> solution to the problem as it stands now.
>
> Thanks. :oD
>
>> Only way I can do this is to type a line of text then hit ALT + ENTER a
> couple
>> of times then type another line of text or pad between with a bunch of
>> <spaces> and turn on text-wrap.
>>
>> If <spaces> try the TRIM function to remove them
>>
>> If ALT + ENTERs turn off text-wrap to see if there are square boxes
> between
>> lines.
>>
>> If so, edit>replace
>>
>> what: ALT + 0010
>>
>> with: <space> or nothing
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Tue, 22 Nov 2005 16:44:43 -0500, "StargateFanFromWork"
>> <noSpam@NoJunkMail.com> wrote:
>>
>>> If the text is too widely spaced apart between sentences in a cell, is
> there
>>> a way we can scrunch them closer together similar to what we can do in a
>>> word-processing program when we change line height? Tx. :oD
>>>
>
>
And why can't you change row height or column width??? Or cut down on
the amount of text you're using? Or print in landscape mode instead of
portrait? Or use more than one page?

Bill

Bill

Bill

[StargateFanFromWork]

"Bill Sharpe" <billsharpe@nsadelphia.net> wrote in message
news:%2367pZLA8FHA.3048@TK2MSFTNGP10.phx.gbl...
> StargateFanFromWork wrote:
> > "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> > news:7r57o19kolofst9ib55k496ud24pju65og@4ax.com...

[snip]

> And why can't you change row height or column width??? Or cut down on
> the amount of text you're using? Or print in landscape mode instead of
> portrait? Or use more than one page?

Been there, done that. I'm at the threshold of the space involved. There
are 12 months in the year and just had a tiny bit too much text in all the
cells involved. Couldn't be helped. Wasn't worth spilling over to 2 pages.
The only way to have fixed this would be to scrunch down the lines. I've
done that so many times in WordPerfect and Word that know the space would
work fine if that were a possibility in E2K. I'm working with text that
fits on 3.75 x 6.75" sheets which are cut out of a legal-sized paper to fit
into Daytimer planners. There wasn't much that could be done as I needed
all the info that is now in the space I was working with.

I didn't just make up the problem <g>. It's very real. No line spacing, no
solution. Doesn't matter now. Can't do anything about it though gave it my
best shot and we'll live with it as it is. Certainly don't want to do this
in Word as there isn't the ease of Excel formulas there to work with.
Despite this problem, E2K still the best for this.

Thanks. Cheers! :oD

[mike_hill]

Its many years later and I had the same problem, but found an easy work-around.

I changed the font to Veranda and it tightened up the line spacing. Others will also tighten up the spacing but Veranda is a nice font imo. Have a play with your available fonts, you may just find what you want.
PS I signed up just to make this post, I hope it helps.

[FDibbins]

Mike, thanks for the update

[bruce2]

mike_hill. - Your simple idea solved my problem. I changed from Helvetica to Veranda and reduced the line spacing dramatically. Thank you for sharing.

[aquixano]

Thanks Mike - I was searching for this very solution and the Verdana font worked for me too.

[Granddad]

Magic Mike, Thank you
Your solution is excel-lent.
You solved my problem with a 10 min search.
I would have liked to reply in Verdana but it not available here
Go Bless
Granddad

[zemal8]

GUYS!!! I have been having the same problem and found a workaround!

Problem: If you decrease row height to be the exact same height as your text, some of the text, either at the top or at the bottom, gets cut off in the white space that are built into the inside margins of the cells (i.e., text gets cut off before it reaches the theoretical border of the cells, resulting in white space between rows of text).

Solution: FOR SOME REASON, at least for Excel 2010 which I'm using, cells that have been subjected to Merge&Center will NOT have the text cut off; instead you will have text that goes all the way to the top and bottom border of the cells (at least when saved as PDF).

I don't know why this is the case, but I'm going to exploit this phenomenon to make super-tight lines for my insect labels. In the attached file, the label on the left is made with Merged-Centered cells, and the one on the right isn't.

I'm not sure that this is what everyone on this thread is looking for, but for me, it certainly is a good enough workaround.

Cheers!

Zemal8