the line is extending to the next cell
 

Hi,
Could anyone pls help on this?

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

Bst Rgds,
HuaMin

the line is extending to the next cell
 

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

the line is extending to the next cell
 

Format the cell to "wrap text"


Gord Dibben MS Excel MVP

On Mon, 26 Apr 2010 01:23:02 -0700, 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

the line is extending to the next cell
 

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

the line is extending to the next cell
 

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