Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to format a cell so that it only displays its contents in the
current cell rather than appearing to "bleed" over to the adjoining cells. In other words if the cell contained the text string "Now is the time for all good men" and the cell was only 10 characters wide, on-screen you would only see "Now is the" because that is all that would display. If this was in cell A1, cell B1 would appear empty. What happens now is that the contents just display across all the cells it needs in order to show the whole sentence. I don't want to wrap the text. I don't want to change anything in any way other than have the contents appear truncated so B1 is "empty". Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |