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) |