cells
 

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

Click on <Format<Cells<Alignment<Wrap text

That will wrap text within a cell and increase the height of the cell. To
do this click on <Format<Row<Autofit

Regards.

Bill Ridgeway
Computer Solutions

"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

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

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

Glad to hear that !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Yem" wrote in message
...
Thank you Bill and Max.

It solves a lot of my problem.

Yem