| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I don't want my text to wrap
I have a cell where WrapText (format, cells, alignment, wrap text) is
set to Off. When I add text to the cell that contains line breaks, Excel changes the formatting of the cell, and WrapText is set to On. I have to manually turn WrapText Off for that cell. I have written a macro to turn WrapText Off for a cell. But I would rather Excel not change the formatting in the first place. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I don't want my text to wrap
Perhaps this will help?
http://vbaexpress.com/kb/getarticle.php?kb_id=579 **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Tom" wrote in message oups.com... I have a cell where WrapText (format, cells, alignment, wrap text) is set to Off. When I add text to the cell that contains line breaks, Excel changes the formatting of the cell, and WrapText is set to On. I have to manually turn WrapText Off for that cell. I have written a macro to turn WrapText Off for a cell. But I would rather Excel not change the formatting in the first place. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view all text in a merged cell? Wrap text is activated. | Excel Discussion (Misc queries) | |||
| Why won't text in cell wrap. Cell format set to wrap. | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| Some lines of text in Excel field do not wrap text. Please help. | Excel Discussion (Misc queries) | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
Linear Mode
