Text Overwriting next empty cell
 

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.

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

Text Overwriting next empty cell
 

Click on the top left hand corner of your worksheet to select the whole
sheet.
Right click on the worksheet and select 'Format Cells'.
Select the 'Vertical text alignment to 'Justify' and then OK.
Select the whole of your worksheet once more.
Select 'Format' from the top tool bar & select 'Row' then 'Height'.
Set the row height to 12.75 which is standard or anything you like.
This will contain the text whithin the cell without overlapping or word
wrapping.
I'm using Excel 97 but i'm sure its the same for later versions.
Hope this helps


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=561045