Text Overwriting next empty cell

[Guest]

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]

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.

 

[grahammal]

Click on the top left hand corner of your worksheet to select the whol
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 wor
wrapping.
I'm using Excel 97 but i'm sure its the same for later versions.
Hope this help