the line is extending to the next cell

[HuaMin]

Hi,
Could anyone pls help on this?

http://cid-17ec75244bac022f.skydrive.live.com/self.aspx/.Public/t11.doc

Bst Rgds,
HuaMin

 

[HuaMin]

Thanks. Is there any way to avoid that the contents of the cell will extend
to the one beside it, even if the 'beside' cell is empty?

 

[HuaMin]

Simon,
can you pls see this?
http://cid-17ec75244bac022f.skydrive.live.com/self.aspx/.Public/t12.doc

Thanks

 

[Gord Dibben]

Format the cell to "wrap text"


Gord Dibben MS Excel MVP

 

[HuaMin]

Many thanks to all. Mickey, your 1st way is enough!

 

[Gord Dibben]

And that space will probably give you grief at some point.


Gord Dibben MS Excel MVP