View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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