Hi,

I have a workbook with a few tabs.

I find that on one of the tabs I could not wrap text by right click Format
Cell Wrap Text.

However when I copy the cell and paste it on the other tab, the text is now
wrap instantly.

May I know why and how to overcome the problem ?

Thanks

Low

--
A36B58K641

Hi,

My aplology, the title of this post should be "Excel 2002: Why could not
wrap text ?".

I have wrongly pasted earlier title.

Sorry for the inconvenience caused

Low


--
A36B58K641


"Mr. Low" wrote:

Hi,

I have a workbook with a few tabs.

I find that on one of the tabs I could not wrap text by right click Format
Cell Wrap Text.

However when I copy the cell and paste it on the other tab, the text is now
wrap instantly.

May I know why and how to overcome the problem ?

Thanks

Low

--
A36B58K641

This is a guess.

Try removing any existing formatting:
Edit|Clear|Formats

And reapply the format(s) you like.

Mr. Low wrote:

Hi,

I have a workbook with a few tabs.

I find that on one of the tabs I could not wrap text by right click Format
Cell Wrap Text.

However when I copy the cell and paste it on the other tab, the text is now
wrap instantly.

May I know why and how to overcome the problem ?

Thanks

Low

--
A36B58K641

--

Dave Peterson

Hi Dave,

I tried, but still unable to wrap text.

Is there any other solution ?

Thanks

Low

--
A36B58K641


"Dave Peterson" wrote:

This is a guess.

Try removing any existing formatting:
Edit|Clear|Formats

And reapply the format(s) you like.

Mr. Low wrote:

Hi,

I have a workbook with a few tabs.

I find that on one of the tabs I could not wrap text by right click Format
Cell Wrap Text.

However when I copy the cell and paste it on the other tab, the text is now
wrap instantly.

May I know why and how to overcome the problem ?

Thanks

Low

--
A36B58K641

--

Dave Peterson

Is this a merged cell?

Is the wraptext actually working, but just seems to fade out at the end?

I'm not sure what's going on...the more info you provide, the better responses
you'll get.

Mr. Low wrote:

Hi Dave,

I tried, but still unable to wrap text.

Is there any other solution ?

Thanks

Low

--
A36B58K641

"Dave Peterson" wrote:

This is a guess.

Try removing any existing formatting:
Edit|Clear|Formats

And reapply the format(s) you like.

Mr. Low wrote:

Hi,

I have a workbook with a few tabs.

I find that on one of the tabs I could not wrap text by right click Format
Cell Wrap Text.

However when I copy the cell and paste it on the other tab, the text is now
wrap instantly.

May I know why and how to overcome the problem ?

Thanks

Low

--
A36B58K641

--

Dave Peterson


--

Dave Peterson

Hi Dave,

The column that has this problem is not a merged cell.

Under normal condition after I wrap the text for the height cell becomes
thicker and the long ntext arrange nicely in many line if I reduce the length
of the cell.

In my case the text still remains as a single roll when I do the same.

Thanks

Low


--
A36B58K641


"Dave Peterson" wrote:

Is this a merged cell?

Is the wraptext actually working, but just seems to fade out at the end?

I'm not sure what's going on...the more info you provide, the better responses
you'll get.

Mr. Low wrote:

Hi Dave,

I tried, but still unable to wrap text.

Is there any other solution ?

Thanks

Low

--
A36B58K641

"Dave Peterson" wrote:

This is a guess.

Try removing any existing formatting:
Edit|Clear|Formats

And reapply the format(s) you like.

Mr. Low wrote:

Hi,

I have a workbook with a few tabs.

I find that on one of the tabs I could not wrap text by right click Format
Cell Wrap Text.

However when I copy the cell and paste it on the other tab, the text is now
wrap instantly.

May I know why and how to overcome the problem ?

Thanks

Low

--
A36B58K641

--

Dave Peterson


--

Dave Peterson

If the rowheight has been set manually (either via the mouse or the menus), then
excel won't change that rowheight.

You can change that behavior by autofitting the rowheight yourself. Either use
the mouse or format|row|autofit.



Mr. Low wrote:

Hi Dave,

The column that has this problem is not a merged cell.

Under normal condition after I wrap the text for the height cell becomes
thicker and the long ntext arrange nicely in many line if I reduce the length
of the cell.

In my case the text still remains as a single roll when I do the same.

Thanks

Low

--
A36B58K641

"Dave Peterson" wrote:

Is this a merged cell?

Is the wraptext actually working, but just seems to fade out at the end?

I'm not sure what's going on...the more info you provide, the better responses
you'll get.

Mr. Low wrote:

Hi Dave,

I tried, but still unable to wrap text.

Is there any other solution ?

Thanks

Low

--
A36B58K641

"Dave Peterson" wrote:

This is a guess.

Try removing any existing formatting:
Edit|Clear|Formats

And reapply the format(s) you like.

Mr. Low wrote:

Hi,

I have a workbook with a few tabs.

I find that on one of the tabs I could not wrap text by right click Format
Cell Wrap Text.

However when I copy the cell and paste it on the other tab, the text is now
wrap instantly.

May I know why and how to overcome the problem ?

Thanks

Low

--
A36B58K641

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson