Excel 2002: How to reveal path of an open file ?

[Mr. Low]

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

 

[Mr. Low]

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

 

[Dave Peterson]

This is a guess.

Try removing any existing formatting:
Edit|Clear|Formats

And reapply the format(s) you like.

 

[Mr. Low]

Hi Dave,

I tried, but still unable to wrap text.

Is there any other solution ?

Thanks

Low

 

[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.

Hi Dave,

I tried, but still unable to wrap text.

Is there any other solution ?

Thanks

Low

 

[Mr. Low]

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

 

[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.

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