| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Long Numbers as Text cells | Excel Discussion (Misc queries) | |||
| How to transpose a long list of text across cells | Excel Discussion (Misc queries) | |||
| wrapping of very long text in EXCEL 2002 cells | Excel Discussion (Misc queries) | |||
| Long text gets cut off in the cell | Setting up and Configuration of Excel | |||
| Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
Linear Mode
