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? |
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? |
All times are GMT +1. The time now is 12:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com