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


Gord Dibben MS Excel MVP

On Mon, 26 Apr 2010 20:36:01 -0700, HuaMin
wrote:

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

"????? (????) ?????" wrote:

Sorry..., my previous reply is not correct.
Paragraph 2 should read:
Format the alignment, of the cell you are typing in, as 'Wrap Text'
Micky


"????? (????) ?????" wrote:

We..., two options I can think of right now:
1) To type a single space in the 'beside' cell so it will "look like empty".
2) Format the alignment, of the 'beside' cell, as 'Wrap Text'
Micky


"HuaMin" wrote:

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?

"????? (????) ?????" wrote:

First of all - D7 is not BELOW but beside.
Text will, usually, extend to the next cell ONLY if the next cell is empty.
Micky


"HuaMin" wrote:

Hi,
Could anyone pls help on this?

http://cid-17ec75244bac022f.skydrive...Public/t11.doc

Bst Rgds,
HuaMin