View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Text Overwriting next empty cell

If you put something in that adjacent cell, it'll stop that overlap.

You can use an apostrophe ('), a spacebar ( ).

But I like to use a formula:
=""

It's easier to notice and weird enough to remind me why I did it.

Is this a stupid Question? wrote:

Can anybody tell me if there is a way of switching off the fact that when
writing into a cell and the text goes past the column width the text will
spill over onto the next cell to the right if it is blank? I know about
Wrapping text but this cuts the text off at each new word which is not what I
want.


--

Dave Peterson