| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL - unable to get "TEXT" to wrap, even though cell is formatte
Help. I have cut text and pasted into a CELL which is formatted for wrap
text and it WILL NOT WRAP????? I formatted the cell to wrap and even painted other wrapped cells on to it. Even did paste specials and try to work the spacing and it still will NOT wrap???????? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL - unable to get "TEXT" to wrap, even though cell is formatte
The problem is that when you cut and paste, you're also pasting the format
of the source cell. Also, when you cut you can't paste special. You'd have to format the destination cell to wrap text then copy the source cell then paste specialvalues. Then clear the contents of the source cell. -- Biff Microsoft Excel MVP "onerudecat" wrote in message ... Help. I have cut text and pasted into a CELL which is formatted for wrap text and it WILL NOT WRAP????? I formatted the cell to wrap and even painted other wrapped cells on to it. Even did paste specials and try to work the spacing and it still will NOT wrap???????? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL - unable to get "TEXT" to wrap, even though cell is formatte
Have you set the row to "Autofit"?
Gord Dibben MS Excel MVP On Tue, 31 Jul 2007 10:54:02 -0700, onerudecat wrote: Help. I have cut text and pasted into a CELL which is formatted for wrap text and it WILL NOT WRAP????? I formatted the cell to wrap and even painted other wrapped cells on to it. Even did paste specials and try to work the spacing and it still will NOT wrap???????? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL - unable to get "TEXT" to wrap, even though cell is form
I tried to paste values and even "clear format" and the some of the lines are
still running outside the box ??? "T. Valko" wrote: The problem is that when you cut and paste, you're also pasting the format of the source cell. Also, when you cut you can't paste special. You'd have to format the destination cell to wrap text then copy the source cell then paste specialvalues. Then clear the contents of the source cell. -- Biff Microsoft Excel MVP "onerudecat" wrote in message ... Help. I have cut text and pasted into a CELL which is formatted for wrap text and it WILL NOT WRAP????? I formatted the cell to wrap and even painted other wrapped cells on to it. Even did paste specials and try to work the spacing and it still will NOT wrap???????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i am unable to find "Text to speech" tool bar in Office2007 excel | Excel Discussion (Misc queries) | |||
| Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) | |||
| Count the number of Lines in a "wrap text"-cell | Excel Discussion (Misc queries) | |||
| "Wrap Text" problem in Excel 2003 SP2 | Excel Discussion (Misc queries) | |||
| How to ensure that very large blocks of text "wrap" in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
