If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can text too long for cell NOT carry over into cells after it?
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 |
#2
|
|||
|
|||
Can text too long for cell NOT carry over into cells after it?
Check out the options from Format Cells dialog
Select cellsRight clickFormatCells'Alignment' tabText control..'Wrap text' -- Jacob (MVP - Excel) "Greg" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|