Can text too long for cell NOT carry over into cells after it?

[Greg]

I have a cell with a full sentence in it. The cell is too small for that
sentence so of course it carries over the cells to the right of it to display
the whole sentence. Is there a way to have the sentences only show as much
as the width of the cell its in? For my purpose of about 20 columns per
record, it would just be a lot easier if i can have all the cells as small as
i can to work with because it will be imported into another program

 

[Jacob Skaria]

Check out the options from Format Cells dialog

Select cells>Right click>FormatCells>'Alignment' tab>Text control..'Wrap text'

 

[Bruce Sinclair]

Check out the options from Format Cells dialog

Select cells>Right click>FormatCells>'Alignment' tab>Text control..'Wrap text'

And IIRC, if the cell to the right of the one with the long text is not
blank, that text will cut off. You could use a space in the cell to do that
so you didn't see the extra text ? Of course, that might cause other
problems, so be a bit careful.