Thank you Bill and Max.

It solves a lot of my problem.

Yem

"Max" wrote:

Select the column, say col A
Click Format Cells Alignment tab
Check "Wrap text" OK

Now when you type in col A, the text will wrap around
w/o running into the next cell.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Yem" wrote in message
...
hi,

How do I restrict a word to a cell no matter how long the word is? I want
the cell to expand in its row rather than spill over to the other cells. I
also do not want to increase the width of the cell.

Thank you in advance.

Yem