How to prevent word wrap on a cell before line is filled

[Martin C]

I have tried to find a solution to this, but have been unable to correct it.

Using Excel 2003, I have my rows set up for word wrap. When I enter text
into a cell (formatted as General), the row width will update automatically
if the cell wraps. This is how I want it.

The problem is that the row wraps before I have reached the end of the cell
being edited. I can understand that there may be some sort of margin in
place somewhere (although I cannot find any settings for this), but there
are still at least 3/4 characters that can still be entered into the cell
before I would consider it filled.

Is there a way of adjusting this 'margin' so that I can totally fill the
length of a cell before it considers wrapping. It is annoying to have a row
with double row width even though the line in the cell has not wrapped.

Hope I have made myself understood.

TIA

Martin

 

[macropod]

Hi Martin,

What Excel is doing is displaying how much of the text will fit into the cell's width for the attached printer. When Excel decides
that a given word won't fit into the remaining space, it puts the whole word on the next line. If you don't like the result, you can
always hyphenate the word. Note that Excel's wysiwyg abilities aren't as good sa MS Word's, so what is displayed doesn't always
match what will be printed - a print or a print preview will sometimes appeear something different to what appeared on the normal
screen.

 

[Martin C]

Thanks for the quick response. That makes a lot more sense. I thought it was
a bit odd I couldn't find any adjustment settings anywhere.
Cheers.

Martin

Hi Martin,

What Excel is doing is displaying how much of the text will fit into the
cell's width for the attached printer. When Excel decides that a given
word won't fit into the remaining space, it puts the whole word on the
next line. If you don't like the result, you can always hyphenate the
word. Note that Excel's wysiwyg abilities aren't as good sa MS Word's, so
what is displayed doesn't always match what will be printed - a print or a
print preview will sometimes appeear something different to what appeared
on the normal screen.

--
Cheers
macropod
[MVP - Microsoft Word]

I have tried to find a solution to this, but have been unable to correct
it.

Using Excel 2003, I have my rows set up for word wrap. When I enter text
into a cell (formatted as General), the row width will update
automatically if the cell wraps. This is how I want it.

The problem is that the row wraps before I have reached the end of the
cell being edited. I can understand that there may be some sort of margin
in place somewhere (although I cannot find any settings for this), but
there are still at least 3/4 characters that can still be entered into
the cell before I would consider it filled.

Is there a way of adjusting this 'margin' so that I can totally fill the
length of a cell before it considers wrapping. It is annoying to have a
row with double row width even though the line in the cell has not
wrapped.

Hope I have made myself understood.

TIA

Martin