I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel
expands the row and adds a blank line below it. However, there are no
characters on this line so I have a bunch of entries with an extra line of
space below them. I could just go through and manually shorten the width of
these lines, but it will take me all day and the minute I select all the
lines and autosize I will be back where I started.

Is there any way to get Excel to only expand the width when there is
actually a word or character to carry over?

The behaviour you want is the way Excel is supposed to behave.

What happens if you only enter one word smaller than the Col width? Does
Excel add a blank line too?

Suppose you have this problem in the cell A10
Enter =CLEAN(A10) in A11
Do you get the same problem in A11 too or does it go away?

"Arun" wrote:

I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel
expands the row and adds a blank line below it. However, there are no
characters on this line so I have a bunch of entries with an extra line of
space below them. I could just go through and manually shorten the width of
these lines, but it will take me all day and the minute I select all the
lines and autosize I will be back where I started.

Is there any way to get Excel to only expand the width when there is
actually a word or character to carry over?

The CLEAN function doesn't make it work right either - but it was a good
idea. The one-word cell causes the same issue. Say the cell width can hold
5 characters without wrapping (the sixth character falls to the next line).
I put in 'xxxxxx' and it appears as
xxxxx
x

Remove one x and I get
xxxxx
(blank line because the row is still 2 lines high)

Remove another x and I still get the blank line. Remove another x (down to
3) and finally it autofits to the correct row height and has a couple spaces
after the word. I am using a basic Arial 10-point font.

"Sheeloo" wrote:

The behaviour you want is the way Excel is supposed to behave.

What happens if you only enter one word smaller than the Col width? Does
Excel add a blank line too?

Suppose you have this problem in the cell A10
Enter =CLEAN(A10) in A11
Do you get the same problem in A11 too or does it go away?

"Arun" wrote:

I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel
expands the row and adds a blank line below it. However, there are no
characters on this line so I have a bunch of entries with an extra line of
space below them. I could just go through and manually shorten the width of
these lines, but it will take me all day and the minute I select all the
lines and autosize I will be back where I started.

Is there any way to get Excel to only expand the width when there is
actually a word or character to carry over?

I am unable to replicate.

Can you mail the file to me?
Excel version? I tested with 2003.

"Arun" wrote:

The CLEAN function doesn't make it work right either - but it was a good
idea. The one-word cell causes the same issue. Say the cell width can hold
5 characters without wrapping (the sixth character falls to the next line).
I put in 'xxxxxx' and it appears as
xxxxx
x

Remove one x and I get
xxxxx
(blank line because the row is still 2 lines high)

Remove another x and I still get the blank line. Remove another x (down to
3) and finally it autofits to the correct row height and has a couple spaces
after the word. I am using a basic Arial 10-point font.

"Sheeloo" wrote:

The behaviour you want is the way Excel is supposed to behave.

What happens if you only enter one word smaller than the Col width? Does
Excel add a blank line too?

Suppose you have this problem in the cell A10
Enter =CLEAN(A10) in A11
Do you get the same problem in A11 too or does it go away?

"Arun" wrote:

I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel
expands the row and adds a blank line below it. However, there are no
characters on this line so I have a bunch of entries with an extra line of
space below them. I could just go through and manually shorten the width of
these lines, but it will take me all day and the minute I select all the
lines and autosize I will be back where I started.

Is there any way to get Excel to only expand the width when there is
actually a word or character to carry over?

I just sent it.

"Sheeloo" wrote:

I am unable to replicate.

Can you mail the file to me?
Excel version? I tested with 2003.

"Arun" wrote:

The CLEAN function doesn't make it work right either - but it was a good
idea. The one-word cell causes the same issue. Say the cell width can hold
5 characters without wrapping (the sixth character falls to the next line).
I put in 'xxxxxx' and it appears as
xxxxx
x

Remove one x and I get
xxxxx
(blank line because the row is still 2 lines high)

Remove another x and I still get the blank line. Remove another x (down to
3) and finally it autofits to the correct row height and has a couple spaces
after the word. I am using a basic Arial 10-point font.

"Sheeloo" wrote:

The behaviour you want is the way Excel is supposed to behave.

What happens if you only enter one word smaller than the Col width? Does
Excel add a blank line too?

Suppose you have this problem in the cell A10
Enter =CLEAN(A10) in A11
Do you get the same problem in A11 too or does it go away?

"Arun" wrote:

I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel
expands the row and adds a blank line below it. However, there are no
characters on this line so I have a bunch of entries with an extra line of
space below them. I could just go through and manually shorten the width of
these lines, but it will take me all day and the minute I select all the
lines and autosize I will be back where I started.

Is there any way to get Excel to only expand the width when there is
actually a word or character to carry over?

Actually, I had a delivery notification. What's your address?

"Sheeloo" wrote:

I am unable to replicate.

Can you mail the file to me?
Excel version? I tested with 2003.

"Arun" wrote:

The CLEAN function doesn't make it work right either - but it was a good
idea. The one-word cell causes the same issue. Say the cell width can hold
5 characters without wrapping (the sixth character falls to the next line).
I put in 'xxxxxx' and it appears as
xxxxx
x

Remove one x and I get
xxxxx
(blank line because the row is still 2 lines high)

Remove another x and I still get the blank line. Remove another x (down to
3) and finally it autofits to the correct row height and has a couple spaces
after the word. I am using a basic Arial 10-point font.

"Sheeloo" wrote:

The behaviour you want is the way Excel is supposed to behave.

What happens if you only enter one word smaller than the Col width? Does
Excel add a blank line too?

Suppose you have this problem in the cell A10
Enter =CLEAN(A10) in A11
Do you get the same problem in A11 too or does it go away?

"Arun" wrote:

I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel
expands the row and adds a blank line below it. However, there are no
characters on this line so I have a bunch of entries with an extra line of
space below them. I could just go through and manually shorten the width of
these lines, but it will take me all day and the minute I select all the
lines and autosize I will be back where I started.

Is there any way to get Excel to only expand the width when there is
actually a word or character to carry over?

Click on my name and remove the first part after the @ sign...
I am trying to avoid spammers...

"Arun" wrote:

Actually, I had a delivery notification. What's your address?

"Sheeloo" wrote:

I am unable to replicate.

Can you mail the file to me?
Excel version? I tested with 2003.

"Arun" wrote:

The CLEAN function doesn't make it work right either - but it was a good
idea. The one-word cell causes the same issue. Say the cell width can hold
5 characters without wrapping (the sixth character falls to the next line).
I put in 'xxxxxx' and it appears as
xxxxx
x

Remove one x and I get
xxxxx
(blank line because the row is still 2 lines high)

Remove another x and I still get the blank line. Remove another x (down to
3) and finally it autofits to the correct row height and has a couple spaces
after the word. I am using a basic Arial 10-point font.

"Sheeloo" wrote:

The behaviour you want is the way Excel is supposed to behave.

What happens if you only enter one word smaller than the Col width? Does
Excel add a blank line too?

Suppose you have this problem in the cell A10
Enter =CLEAN(A10) in A11
Do you get the same problem in A11 too or does it go away?

"Arun" wrote:

I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel
expands the row and adds a blank line below it. However, there are no
characters on this line so I have a bunch of entries with an extra line of
space below them. I could just go through and manually shorten the width of
these lines, but it will take me all day and the minute I select all the
lines and autosize I will be back where I started.

Is there any way to get Excel to only expand the width when there is
actually a word or character to carry over?