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

  • Thread starter Thread starter Greg
  • Start date Start date
G

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
 
Check out the options from Format Cells dialog

Select cells>Right click>FormatCells>'Alignment' tab>Text control..'Wrap text'
 
Check out the options from Format Cells dialog

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

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. :)
 
Back
Top