| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I stop text displaying in blank adjacent cells?
Excel will always display overflow text in blank adjacent cells. Is it
possible to stop this? |
|
#2
|
|||
|
|||
|
Type a "space" in the cell just to the right of the one containing the
text..........then it will not overflow...... Vaya con Dios, Chuck, CABGx3 "CathyMcK" wrote in message ... Excel will always display overflow text in blank adjacent cells. Is it possible to stop this? |
|
#3
|
|||
|
|||
|
[quote=CLR;46130]Type a "space" in the cell just to the right of the one containing the
text..........then it will not overflow...... Vaya con Dios, Chuck, CABGx3 This is the best answer I have found so far but if you put something in the field and then delete it later it will display in the next cell unless you put a space in there again. Is there a more permanent way to do this? |
|
#4
|
|||
|
|||
|
Cathy,
Or set the cell to wrap text (Format cells - Alignment) -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "CathyMcK" wrote in message ... Excel will always display overflow text in blank adjacent cells. Is it possible to stop this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I clear blank space at the top of a word-wrapped text cell? | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
| In excel and a pivot table - how can I stop it displaying (blank). | Excel Discussion (Misc queries) | |||
| blank cells that include text | Excel Worksheet Functions | |||
Hybrid Mode
